Month Report

[Doc94]

I want to run a report part of which is based on a query with a date/time field. I want the report run each day from the begining of the month without user input of dates. So for example, today is 8/13/03 and todays report would include all of the dates from 8/1/03 through today and tomorrow would be the same through 8/14.
I have tried creating a module MonthlyPeriod with DateSerial(Yr, mnth, 1).................to no avail. Any ideas on code or a macro for this?

 

[PaulBricker]

On the Criteria line for your Date/Time field put
Between DateSerial(Year(Date()),Month(Date()),1) and Date()

That will be from the first of the month till todays date.

Paul