How do I display previous month in Access Report 2

[GreekTony]

Hello,

Basically i have a report which I compile using last months data, and i would like this to be displayed on the report. For example at the moment it is april, so the report should display march.

I have been playing around with the formula below to no avail

=Format(Now(),"mmmm yyyy")

Can anyone help?????

 

[Remou]

Perhaps:
[tt]=DateAdd("m", -1, Date)[/tt]

 

[GreekTony]

Hi Remou your suggestion didnt work I keep getting a enter parameter message box pop up everytime i try and run the report. Thanks for the help tho

 

[GreekTony]

I have modified your formula Remou to this

=DateAdd("m",-1,(Now()))

This then displays:

03/03/2006 14:40:00, which is halfway there as the month shown is March which is correct. How do i now get it to just display the month only? I have played around with the formuala adding in "mmmm" in different places but nothing i have tried works!!!!1 ARGHHH

 

[Remou]

Maybe:
[tt]Format(DateAdd("m", -1, (Now())), "mmmm, yyyy")[/tt]

 

[GreekTony]

Cheers Remou, this work perfectly. Much appreciated