Combining cross tab queries

[brum_rich]

I have a number of cross tab queries which I run on a weekly basis, each of which is running from a different date field in the database (e.g. one query for orders received based on 'Received Date', another for orders complete based on 'Received Date'. On a weekly basis I have to open each query in design view, edit the start and end date for the week and execute the query. It would save significant time if I could enter a date range once into a form and run the series of queries based on these parameters. Any thoughts?

 

[SammyJ]

Have a one record table with the date in it, and link that date to the fields in the queries which need to be restricted to that date.

Then set up a form to edit the date if you want.