I have 10 queries that each require a date range (>=5/1/2012 AND <=5/31/2012). This will obviously change each month and I do not want to go into each query and change this. Is there someway I can setup this range, maybe in a form, so that I can change just the form and it will automatically populate each criteria field in the queries? I'm using Access 2007.
The form must be open to use it in a criteria, but it can be hidden. If you really wanted to close it, you could save the values to a one-record table and join that table in your queries. Not the way I'd go though.