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.

Thanks!

Hawkeye-X

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.