I have about 10 queries that run everyday. In those queries everyday we change one field ( the date fields) then run it . I was able to create a form that calls the query and place the proper date into the query.
But my issue is how can I pass the same date to multiple queries from one macro.
I am sorry I forgot to mention that I would like to have a macro because the output is going to an excell spreadshit. or actually I am open to any suggestions as long as I can click one button put the date click ok , and then have the output in excell.
Thanks in Advance.