I have a several similar queries. Each month I have to change the date range criteria in each one to run my report (ie: >=03/01/04 and <=03/31/04).
Doing this in each query takes too long, and leaves the door open for mistakes.
Is there a way I can set my criteria in each query to tell it to go and read the values from other tables? Ideally, I'd like to see something like this for my criteria: " >=[startdatetable] and <=[enddatetable] " in all of my queries.
Then, all I'd have to do is change the value in the table called "startdatetable" to 03/01/04, and the value in the "enddatetable" to 03/01/04, and that would cover it for all the queries.
I am using Access 2000 on Win98 and am kind of new to Access (to this depth anyway).