Parameter Query to return multiple values
 

I have a query with a parameter which prompts the user to enter a product
code.
The query works fine if the user puts a product code in, but how should the
user enter more than one product code to return a query containing more than
one product code. I have tried AND and OR and have had no luck.

Parameter Query to return multiple values
 

I believe you'll need to post this in the Access forum.
--
Kevin Backmann


"Ruth" wrote:

I have a query with a parameter which prompts the user to enter a product
code.
The query works fine if the user puts a product code in, but how should the
user enter more than one product code to return a query containing more than
one product code. I have tried AND and OR and have had no luck.

Parameter Query to return multiple values
 

Sorry, I should have been more specific with my question. I am working in
Microsoft Excel and importing data via Microsoft Query.

"Kevin B" wrote:

I believe you'll need to post this in the Access forum.
--
Kevin Backmann


"Ruth" wrote:

I have a query with a parameter which prompts the user to enter a product
code.
The query works fine if the user puts a product code in, but how should the
user enter more than one product code to return a query containing more than
one product code. I have tried AND and OR and have had no luck.