create a new table by pulling data from one table IF it does not .

J

Johan

I'd lilke to create a query where I get the results of comparing 2 sets of
samaccountnames and the results I want the the users in the one table that is
not in the other table
 
O

Ofer

Use the query wizard to create an unmatch records query, to create a query
that return records that are in one table but not in the other.
 
M

matz

Go to queries, click on the word new in the toolbar and choose unmatched
query off of the fields you need
 
Top