Display previous month

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

I think this is a simple question. I want to display the
previous month in a report header. The report content
contains data from last month, so I want the header to
say "August Totals" if this month is Sept.

Thanks!
Melissa
 
Melissa said:
I think this is a simple question. I want to display the
previous month in a report header. The report content
contains data from last month, so I want the header to
say "August Totals" if this month is Sept.

Thanks!
Melissa
Click to expand...

If you're basing this on the current system date, you could use a
controlsource expression like this:

=Format(DateAdd("m", -1, Date()), "mmmm") & " Totals"
 
Back
Top