Dec 31 2009, 11:09 AM
I would like to resuse data from a query prompt. For example, I prompt the users to enter a date for a sales query and I would like to resuse that date instead of prompting the user to re-enter that date. thank you
Dec 31 2009, 11:12 AM
There isn't any way of passing parameters from one query to another.
You can use a textbox on a form to enter the date and you can then refer to it in any query you want to run..
The form must be open when you run the query.