Filtering month

[Unicon]

Dear all,
How can I filter Months in query as I have a date in format as below

January 2011
February 2011
March 2011
January 2011
February 2011
March 2011

I want to filter previous month (say March 2011). I tried {Month(Now())-1} but not working.
Please advice.

 

[MStef]

Look at "DemoMarchA2000.mdb" (attachment, zip).
Look at table, query. Run Query1.