Aug 13 2004, 01:36 PM
I created multiple queries which basically asks for the same data range for all of its queries. Is there any way I can use the one data range to be applied to those multiple queries?
If so, please let me know. Or if you don't understand, please let me know.
Aug 13 2004, 02:22 PM
Just add a form with the parameters you want to use (i.e start date and end date etc...)
the in the query add in the criteria of the field you wish to read these values
between forms![formname]![fieldname1] and forms![formname]![fieldname2]
where fieldname1 and fieldname2 are the fields on your form
Just to point out that the form needs to be left open whilst running these queries
Edited by: dannyseager on 08.13.04.