Link to home
Create AccountLog in
Avatar of lrollins
lrollinsFlag 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??
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

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
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of 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.
ok, upload a sample db and explain in details how to proceed with the criteria
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.