Parameter Query

[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

 

[KARL DEWEY]

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

 

[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