Copy Query Parameters (MS-Access-2003) from another Query.
Posted on 2008-06-13
How can I copy Query Parameters from another query?
In the Column where I'm specifying the parameters (within a query) - Can I just point it to look for the parameters show in another query within the same database?
Both Queries have a PPEndDate parameter that reads: Between #10/13/2007# And #6/7/2008#
I want the 2nd Query - to look at the first one and replace it's date parameters with what it sees in the 1st query.
Is there a simple way that I can write this in write into the column?
Please assist... Thanking you for your timely feedback & help, sincerely, Raj.