comparing multiple fields

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

Guest

I am trying to compare a database with a dept. and shift field to another database with that has the same two fields to see if they match. It will then return an email address from the first table where dept./shift did not match. Any ideas on how to write that?
 
Try the Unmatched Records Query wizard.

HTH
- Turtle

Fish said:
I am trying to compare a database with a dept. and shift field to another
Click to expand...
database with that has the same two fields to see if they match. It will
then return an email address from the first table where dept./shift did not
match. Any ideas on how to write that?
 
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

comparing multiple fields 1
VBA Help please 2
Access Automatically Send a notification email once a record is added 0
Indexes, Primary Keys, and Forms 9
Error message regarding duplicate values 1
Can one table's record affect another tables record? 3
Use single entry in one table to generate multiple in another 1
Access Compare records in same access table 0

Back
Top