Including date in report header

[Toolpusher]

Hi

I created a report in access 2003 that gives me last months stats. The header reads "Summary of Observations submitted" I want it to read "Summary of Observations submitted Feb 2011" I have inserted a text box after submitted but end up with the date format as 17/03/2011 anyone help please

 

[HiTechCoach]

You can use the format() function to change the format.

Example:

Format([myDate], "MMM yyyy")

 

[Toolpusher]

Thankyou got in now

 

[HiTechCoach]

You're welcome. Glad we could assist.