I know how to setup criteria based on one value. And I also know how you can use the "or" row to add another criteria. But what is you have a list of 20-25 names to add to the criteria?
I have a table of sales orders shipped that is 1,000's of records. Each line has a project manager. I want to query this table based on a group of project managers. There has to be an easier way to do this than typing in all of their names in each of the queries.
For example, I want a list of all the sales orders that were from (insert list of 25 project managers) or a want to see the sales orders that (insert list) were not on.
Can I use a column in another table as a criteria? It seems like I'm just using the wrong terminology and there is an easy solution.
*I want to do this actually in Access and not VB.