I have a designed a query to pull information based on a project number. When I run the query, I can type in the criteria box "Proj1" or "Proj2" or "Proj3" and I will get the information for all three projects.
I would like to put this query in a switchboard and prompt the user for the project number. I typed [Enter Proj Number] in the criteria box. When it prompts for the project number I cannot use "or" to get information on more than one project.
Any idea how I can accomplish this. I do not want the user to have to query the database five different times to find the information on 5 different projects. I would like them to be able to enter the projects all at the same time.