Monthly Report

[mhockey88]

Hi, I'm still very new to Access having only started using it a few weeks ago. I've managed to create a simple one-to-many relationship that shows Issues and the Actions associated with each Issue, and now I want to generate a report each month which shows the data without having to go in and customize the formatting etc. of my report each month. What is the best way to go about this? Any help is very much appreciated!

[burrina]

You could use a popup form for your date criteria or a normal date criteria form menu. Or even use a hard coded module. Up to you.

HTH

[mhockey88]

Thanks burrina, could you give me a quick rundown of the pros/cons of those approaches? I need to leave behind something that is easy for someone else to repeat since I'm only at my company for a few more weeks (intern) and am wondering what the simplest method might be? (while at the same time not sacrificing quality for a quick fix, if that makes sense)

[burrina]

My personal choice is a Date Criteria Form, but each to his/her own.