How to pull data based on 74 specific criteria

[mbtedrick]

I am not sure if this is possible in Access or Excel for that matter...
In my data I have a field Client PO. I am working on a project where I need to pull all line items associated with about 74 different PO #. There will potentially be additional lines of data added with these PO's. So I would like to create a query that I could run that would pull all data with these 74 PO#'s. What is the best way to handle? Is it possible?

Thank you,
Ellen

 

[Joe4]

Create a table that contains all 74 POs that you want.
Then, create a query between your data table and this criteria table, joining them on the PO field. Select the fields from your data table that you want to see.
This query will only return records where the POs exist in both table (i.e. the "matches").