Noob Query

[Joskin]

Hello Gurus,

I have inherited a db that has two tables.
Table 1 has a Names field and info in other fields. It has 847 records.
Table 2 has a Names field and different info in other fields. It has 693
records.

The 693 Names in Table 2 are in Table 1 but I need the list of Names from
Table 1 that are NOT in Table 2.

I can't get my head round the query that I need (Access 2003)
Any pointers would be appreciated.

Joskin

 

[Roger Carlson]

Check out the Unmatched Query wizard when you select New Query.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Joskin]

Roger,

That was perfect !

Many Thanks,
Joskin

Check out the Unmatched Query wizard when you select New Query.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L