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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Go to queries, click on the word new in the toolbar and choose unmatched
query off of the fields you need
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
How to Populate Data from a table to another 0
Have both records from two queries/tables under one Query without related fields. 0
Query comparing two fields in a table gives wrong results-why? 3
Capturing data from two tables... 5
Delete Query: Could not delete from specified tables 0
query tables using multiple listed values from another table 1
Pulling data from multiple tables of same structure 5

Back
Top