Design of Query

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

I have two tables and I would like to perform an
unmatched record query based on the fields. How should I
proceed?


First Table Second Table
looks like this) looks like this)

CANPV Noncom2

Actv Actv
Awd Tot $(byCAN) Future Year 1
Future Year 1 Future Year 2
Future Year 2 Future Year 3
Future Year 3 Future Year 4
Future Year 4 Future Year 5
label Full Grant # Label: Full Grant #
 
Allison, can you be more specific:
I assume you are looking for records in one table that are not in the second table. Which
fields are involved in the match? All fields or just a couple?

One quick way I do it if the match is on one field only is to set up a query with a left join and set
the criteria in the in the second table matched field to "Is Null"
HTH
SMK
 
Back
Top