Display Prior Month/Year on Report Header 1

[TimothyP]

I am running Access 97.
My input file does not have any Date fields at all.
The input file will always contain last months data.

I created a valid report displaying the data.

How would I go about adding a report heading that would display the prior month/year.

Examples:

If I printed the report in January 2007, my report header should read 'December 2006'.

If I printed the report in February 2007, my report header should read 'January 2007'.

If I printed the report in March 2007, my report header should read 'February 2007'.

Any ideas?

Thanks in advance,
Tim

 

[PHV]

What about this ControlSource ?
=Format(DateAdd("m",-1,Date()), "mmmm yyyy")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TimothyP]

Thanks PHV!

That's exactly what I needed.

Tim