Parameter Query Question

[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

 

[Rick Brandt]

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-*)]

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.

 

[Michel Walsh]

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