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
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