Parameter Query Question

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

I have 2 Parameter prompts in one query. Both Parameters
need the exact same information for 2 different fields.

When I run the query, I only get prompted once. Is this
correct, or should it be prompting me twice, once for each
Parameter. Again for both prompts, the exact same
information is needed.

Here is my Parameter:

Like [Enter a 2 digit "Department Code" followed by an
Hyphen and Asterick ( ie: PS-*)]

Thanks. DaveB
 
DaveB said:
I have 2 Parameter prompts in one query. Both Parameters
need the exact same information for 2 different fields.

When I run the query, I only get prompted once. Is this
correct, or should it be prompting me twice, once for each
Parameter. Again for both prompts, the exact same
information is needed.

Here is my Parameter:

Like [Enter a 2 digit "Department Code" followed by an
Hyphen and Asterick ( ie: PS-*)]
Click to expand...

Anytime the text within the parameter is exactly the same, you will only be
prompted once and the entered value will be applied to all the parameters.
If you change just one character, then you will be prompted twice.
 
Hi,


It is correct to be prompted once and only once for a given parameter,
even if that one occurs multiple time. Change the parameter name if you want
be prompted many times (like [Enter first ] and [Enter second] )


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top