Hi,
I have multiple tables with roughly the same information in each but each one for different clients.
At the moment there's a query set up for each of these which asks for start and end date parameters when run. I have a macro that runs each of these in turn and dumps them as an excel file onto my hard drive. What I'd like is to only have to enter the parameters in once and have this shared across all of the queries. How would I go about this?
The alternative would be to use an append query and then dump the output of that but I'm not having much luck with that so i'll save those problems for another question.
thanks
Nick
I have multiple tables with roughly the same information in each but each one for different clients.
At the moment there's a query set up for each of these which asks for start and end date parameters when run. I have a macro that runs each of these in turn and dumps them as an excel file onto my hard drive. What I'd like is to only have to enter the parameters in once and have this shared across all of the queries. How would I go about this?
The alternative would be to use an append query and then dump the output of that but I'm not having much luck with that so i'll save those problems for another question.
thanks
Nick