Dynamic Report Header

[brad]

Is there a way to add a dynamic report header to access report?

[pbaldy]

Probably depends on what you mean by a dynamic report header.

[brad]

Got it. Let me try to explain. The report is for business partner performance over the previous month. Every month the report would be run for the next month so I didn't put a standard date on the report heading. Is there a way to have Access/VBA read the date stamp (April 5, 2013) and add a heading of March 2013 (1 month prior) to report heading?

[pbaldy]

Try

=Format(DateAdd("m",-1,Date()),"mmmm yyyy")

[brad]

Thanks. I'll give it a shot.