Query with list of criteria for same field

[crowley131]

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

 

[CJ_London]

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

 

[crowley131]

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.