Parametric query with Multiple Answers

[Gregshah]

I would like to develop a query to pull information about a single job number or in some cases, a group of job numbers. Can I use a parametric query that will let me enter a single job number or multiple? I tried putting commas, semicolons, spaces etc to separate the job numbers but it did not work.

Thanks for your help,

Greg

 

[lespaul]

the easy answer is "no", you can't do a parameter query like that...there are a few FAQs that explain how you can do it but they are based on what kind of control you are providing to the user to select the "multiple" choices.

You can try:
FAQ701-4696
FAQ701-6099


Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[dhookom]

I hate parameter queries and don't think they should ever be used faq701-6763.

SELECT Employees.*
FROM Employees
WHERE "," & [Enter Employee IDs] & "," Like "*," & [EmployeeID] & ",*";

I would use a multi-select list box on a form for this rather than a parameter prompt.


Duane MS Access MVP
Now help me support United Cerebral Palsy