Automatic Monthly Reporting 1

[MelissaBerrett]

Every month I have to update my queries to report only for the current month by changing my parameter dates to equal that of the current month. Then I change my report headers to display Jan, Feb, March, ets. Is there a way to do this automatically do this each month?

 

[PaulBricker]

If you run the report in the current month then do this
Put this expression in a new column in your query.
MyMonth:Month([YourDateField])

and on the Criteria line put
=Month(Date())

Then just use Format(Date(),"mmmm&quotin your Header.

Paul

 

[MelissaBerrett]

To cool, Thanks!