Delete querry?

[unsure]

I have 2 tables. Table 1 is the master table (contains all records). Table 2 contains a smaller number of records. Each table has the exact same layout. In each table there is a field called "code". In table 1 that field is always empty. In table 2 that field always has a value. I am trying to find a way to create a 3rd table that contains all the records from table 1 except for the records in table 2. Any help would be greatly appreciated.

 

[BanditWk]

For this, I would use the UnMatched Query Template, then set the type of Query to MakeTable... You can modify the Is Null criteria to Is NOT Null if you want the reverse affects...

Roy
aka BanditWk
roy@cccamerica.org