Display previous month

[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

 

[Dirk Goldgar]

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

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"