formatting the result with the appropiate date format. This produces a string that you can concatenate to the string "Monthly Report". The function to use is Format.
In the header of an Access report, I want the current date MINUS one month to automatically appear, and I need a specific formatted result too.
Examaple of the result I need is: "Monthly Report July 2006".
When I try the following formula I also get the day and all I want is the month and year: ="Monthly Report " & DateAdd("m",-1,Now())
Any suggestions? Thank you.