Un-Append Query

[Tom123]

Hello, I am fairly new to access and I would like to do the following:




Say I have two tables, each with only one field which is Metal Name. The tables contain:

Table 1: Steel, Aluminium, Copper, Zinc
Table 2: Aluminium, Zinc

I want to use table 2 to remove records from table 3 so I get:

Table 3: Steel, Copper

Basically Table 3 = Table 1 - Table 2

But I cant seem to make it show me what I want in a query. Is this possible? If so, How? I know there is a Delete Query but my problem is that I cant get any query to find the elements I want to delete. I managed to make it find the elements in both tables (Aluminium and Zinc) but I cant get it to show me the opposite.



Cheers,

Tom

[JoeM]

An Unmatched query will show you the records from Table1 that are not in Table2. There is even a Wizard under the Query Wizard that will set that up for you.

[Tom123]

Thank you that works perfectly