Parameter Value in a Query

  • Thread starter Thread starter Mezzo Anna
  • Start date Start date
M

Mezzo Anna

I am running an Output To macro from a Query with a parameter value prompt.
I need to run this 6 times with different values for the same field. How do
I enter the value within the macro so that I don't need to manually enter it
when the macro runs?
 
I am running an Output To macro from a Query with a parameter value prompt.
How do you do this?
So far as to 6 different criteria for your query use a form with datasheet
view bound to a Criteria table. Fill in your criteria, one per record. Use
the Table/Field as criteria in your query.
 
My Macro does:

Action: Output to
Object Type: Query
Object Name: Query Name
Output Format: Microsoft Excel 97-2003 (*.xls)
Output File:
Auto Start: No
Template File:
Encoding:

Once the macro runs, the operator responds to the prompt by entering the
required text (which will always be the same six values, the names of our
regions)
 
Back
Top