Sequential Queries

[Harley]

I have a macro set to run 10 queries, is there a way to
set the macro to where it runs all the queries with the
same criteria. Example if I wanted to use between [please
enter starting date] and [please enter ending date] for
every query that the macro would run.

Thanks

 

[Douglas J. Steele]

Easiest way would be to have a form where the user enters that information,
and then have all 10 queries point to the form to get the values, rather
than simply putting [please enter starting date] and [please enter ending
date] as the parameter names.

Another advantage of this approach would be that you could have a calendar
on the form, to make it easier for them to select dates.