My table contains a Customer ID field. The Customer IDs are 6-digits and are stored as text. I would like to do a query which pulls records for 100 specific Customer IDs, and I currently have those IDs saved in a text file.
However, in the Criteria field within Design View, I don't want to manually type in:
<Customer ID1> OR <Customer ID2> OR <CustomerID3> OR.... <Customer ID100>
Is there some way that I can simply refer to the text file which contains my list of Customer IDs in the following format:
Customer ID1
Customer ID2
...
Customer ID100
If not, can you recommend any other shortcut for entering multiple text values in the Criteria field of the Design View?
Thank you!