Parameter Query

J

Jay

I have a query which prompts for a parameter value.

I want to use the value twice in the same expression. How can I do this
without repeating the parameter prompt.

Any help welcome.

J
 
K

KARL DEWEY

Just copy and paste it in the second location. If it is identical it will
only prompt once.
 
A

Andy Hull

Hi Jay

Just repeat the same parameter prompt wherever you need it in your query.

When the query runs it will only ask for each different parameter once.

Andy Hull
 
Top