LiamOfFoxchase
New Member
- Joined
- May 23, 2005
- Messages
- 13
Access gurus,
I have a macro which runs a series of queries. 3 of these queries use the same value for a criterion, Fiscal Quarter. Right now, I go into Design View of each query and change the Fiscal Quarter manually. I'd like to automate this by entering the value once, and ideally I'd like to include this input at the beginning of the macro.
Any ideas?
Thanks,
Liam
I have a macro which runs a series of queries. 3 of these queries use the same value for a criterion, Fiscal Quarter. Right now, I go into Design View of each query and change the Fiscal Quarter manually. I'd like to automate this by entering the value once, and ideally I'd like to include this input at the beginning of the macro.
Any ideas?
Thanks,
Liam