Display previous month

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
 
D

Dirk Goldgar

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"
 
Top