Access Query to list data on table but not on another table?

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I am successfully pulling data fields from table-A to table-B based upon
record field relationships. Now I would like to write a query to tell me
when table-A has additional records that need to be pulled into table-B. An
exception query, if you will.
 
I would just use a query with both tables joined. Then use a new column with
Are they equal:IIF([field from 1st table]=[field from second
table],"yes","no")
 
If you use the same query and create an outer join instead of an inner join
(right click the line between the tables in the query designer and select
J"oin properties" and then "Show all records from table a and only those
records from table b where the joined fileds are equal") then add "is null"
(without the quotes) to the criteria field of any field from table a, it
should return records from table a that do not have related records in table
b.

Adam
 
Back
Top