Avatar of lrollins
lrollins
Flag for United States of America asked on

Multiple criteria for one field in access query

I need to be able to compare two tables but need to input the criteria based on one table and then have it show me the mismatched records between the two.  Anyone have any ideas??
Microsoft Access

Avatar of undefined
Last Comment
PatHartman

8/22/2022 - Mon
Rey Obrero (Capricorn1)

use the query wizard, select Find Unmatched query wizard

as for  the multiple criteria, you use

field
table

criteria  in(1,2,3)   , for number type fields

               in("1","2","3")   , for text type fields
ASKER CERTIFIED SOLUTION
PatHartman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
lrollins

ASKER
Yes but it has to be based a certain criteria from one of the tables and this criteria would be put in by the user.
Rey Obrero (Capricorn1)

ok, upload a sample db and explain in details how to proceed with the criteria
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
PatHartman

Start by getting the basic query built.  There are a number of ways to provide criteria.  you'll need to tell us how you want to do it and how variable it is.