Set report criteria

[IanT]

I want to open a report that displays a form with different month options as the criteria to filter the report. Can anyone advise the best way to do this!

 

[David R]

Put a field in your underlying query: MonthSelection: Format([DateField],"mmmm"). Then in the criteria put [Enter the full name of the month you wish to view] - you can also use "m", "mm", "mmm".

This can be adapted to Between [Enter starting month] And [Enter ending month], and a myriad of other options.

If you're not familiar with parameters, I apologize. Look them up in the archives or Access help and post back if you need further assistance.

Good luck,
David R