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.