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?
 
Back
Top