Skyshadow5
Technical User
Hi, I have 28 separate queries that need to be run and each one has a need to return data between two dates so my queries use the "Between [Start date] And [End date]" criteria. However this means that with 28 queries I have to manually type in the same start date and same end date 28 times which is not very productive.
Is it possible to have a table that simply stores two dates, a Start Date and an End Date, that can be updated before running the 28 queries and for the queries to use these two dates as the criteria for the start and end dates?
If it is possible than I can put all 28 queries into a Macro and just let it run through them all knowing that each one is picking up the same Start Date and End date and have the Macro drop them all into one location.
Thanks in advance,
Clive
Is it possible to have a table that simply stores two dates, a Start Date and an End Date, that can be updated before running the 28 queries and for the queries to use these two dates as the criteria for the start and end dates?
If it is possible than I can put all 28 queries into a Macro and just let it run through them all knowing that each one is picking up the same Start Date and End date and have the Macro drop them all into one location.
Thanks in advance,
Clive