Query with list of criteria for same field

crowley131

New member
Local time
Today, 07:27
Joined
Oct 17, 2013
Messages
4
Hi,

I think this should be straightforward, but cant figure out how to do it.

I have a list of unique customer IDs, about 200. I want to display all of the customers with these IDs.

I have created a query, but when i copy/paste the ID's into the CustomerID criteria the message 'the text is too long to be edited' appears.

Does anyone know how to acheive this?

Thank you in advance
 
I would put the id's in another perhaps temporary table then link that table to your query on the ID. It will be much simpler to manage as well
 
I would put the id's in another perhaps temporary table then link that table to your query on the ID. It will be much simpler to manage as well

Thank you so much!

Just saved me hours of going through each record individually.
 

Users who are viewing this thread

Back
Top Bottom