Access query w/ 2 linked tables

  • Thread starter Thread starter Nadia Negron
  • Start date Start date
N

Nadia Negron

HI to all! I desparately need help. I'm not even sure if
this is possible using an access query or not. I've been
thinking that there must be some type of expression I can
come up w/ to place in the criteria.
Here's my scenario:
Each table has a field called "Facility Map" which consist
of a number such as 1234-5678-01. One table has more
facility map number listed than the other. I'm trying to
filter or pick out the facility maps that were added to
this table and do not exist in the other table. Is this
just a simple filter or something? Plz help.

Thanks in advance to any replies.

~Nadia
 
Try the "Find Unmatched query wizard" when selecting new
query and let the wizard guide you.

Glenn.
 
Back
Top