I have over 100 individual queries, all with date fields. I now want to create a single query gathering information from all those original queries, and this will then be the basis for a report.

Can anyone advise me on how I can best link the date fields of those 100+ queries, so that when I run the single big query/report, I only have to specify the required date once?

Thanks,

Gary Rodger

[This message has been edited by Gary Rodger (edited 08-01-2001).]

You could have a small form that has one (or more) textbox control where the desired date information would be entered. Then all the queries would have the WHERE criteria set to the value in the textbox control(s).

Thanks for the tip Kman, I'll try it out tomorrow.

100 queries all referenced by the same date field isn't there a design flaw?