How To Do An Update Query When You Need To Do ~1000 more "Criteria or"?

[pchanger]

Hey guys,



How do I do an Update Query when the "Criteria" I need to search for is around 1,000 unique strings of gibberish.



I have a list of them in Excel like this:



I was hoping that I could just paste them all, but it is making me enter them one at a time which is not practical. What is the correct way to do this?

Sorry if it's a dumb question. I'm new to Access and wasn't able to find anything about it on YouTube. Maybe I'm searching for it the wrong way. :/

~Luke

[JoeM]

I would make a table of them (a one-column table), and simply link this to your main table on this field.
This would only return the records in your main table that have matches in the new one-column table.

[pchanger]

Thank you so much! That worked!

[orange]

You can use similar technique to exclude certain values from a query. Here's a link to tutorial.

[JoeM]

You are welcome.

[ssanfu]

Welcome to the forum...


Somethings you should know about naming objects is:
Object names should be letters and numbers. Do not begin an object name with a number.
NO spaces, punctuation or special characters (exception is the underscore) in object names.
Do not use Look up FIELDS in tables, multi-Value fields or Calculated fields in tables.

A field named:
- "Price/tag" has a slash - better would be "PriceTag" or "Price_tag".
- "Amazon Link" has a space - better would be "AmazonLink" or "Amazon_Link"

[pchanger]

Yeah, I messed up with the names. Imported from excel. My bad. Very new to access. haha

Thanks for all the help guys, seriously!

~Luke