Parameter Query - Multiple Selection - Quick Question

G

Guest

I have many parameter queries that work great. However, is there a way to
construct a parameter query so you can input multiple selections. For
example, one query prompts for Item#, you enter it and the records return
just fine. However, is there a way to enter 2, 3, or 4, item numbers? I
remember QMF (another SQL program) you could enter multiple selections
seperated by a comma and it would return those records. Is there a syntax
that will work in Access?

Thanks,
Sean
 
G

Guest

I was just trying to do that last week. If I was hard coding the values in I
would use IN(x, y, z) but couldn't figure out if I could prompt a user for
multiple values that way. I ended up using OR and prompting for multiple
parameters. I set it up for 4 values. In my case if the user only had one
parameter to enter and just pressed enter on the remaining prompts it still
would work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top