two tables in Access. Table 1 has 6000 records table 2 has 200. I.

[napolar]

I have two tables in Acess that I need to compare. The first has about 6000
records the second has 200. I need to know all of the records in Table 1
that are NOT in table two.

 

[Rick B]

Build an unmatched query.

The wizard will walk you through it.