George_Milton
asked on
MS Access Query, share parameter/ criteria to another query
Hi
I have 15 queries that I need to run each month. Each query has a field named sladue, and a criteria of like */05/2013*. This field uses a module to add working days to a date field, so the like is to capture all events within that month.
Each month I have to make this change 15 times, which is a pain. Is there away the criteria in this field could be shared, so I only need to change it once and all query's will pick up the correct date?
Cheers
I have 15 queries that I need to run each month. Each query has a field named sladue, and a criteria of like */05/2013*. This field uses a module to add working days to a date field, so the like is to capture all events within that month.
Each month I have to make this change 15 times, which is a pain. Is there away the criteria in this field could be shared, so I only need to change it once and all query's will pick up the correct date?
Cheers
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.