J
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
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