Select Records with Date 30 days prior to the last day of previous month

[oliver.marshall001]

For the mothly report that I have to produce I need to organize the data from an automated report that is generated at the end of each month.



I'd like to write a query that can select records from this automated report that are dated 30 days or less from the last day of the prior month. For example, if I were compiling my report today, 9/5/14, then I'd want all records dated between 8/31/14 and 8/1/14. The date field in this report is called "TransTime."

I'm fairly inexperienced with access and have little exposure to SQL so any help with this would be greatly appreciated.

Thanks in advance.

[pbaldy]

Try this in the query criteria on the date field:

Between DateSerial(Year(Date()), Month(Date()) - 1, 1) And DateSerial(Year(Date()), Month(Date()), 0)