this month minus 1 5

[sedgely]

I am setting up a query to run on the first day of each month, what i want it to do is to return records where the date is within the previous month. I've figured out that i need to firstly work out the month part of todays date and then to return all records where the date is "month - 1". but i can't figure out how to actually do it, any suggestions anyone?

Cheers
Craig

 

[RivetHed]

not a problem