Identifying then deleting duplicates from two tables two produce a 3rd table

[oggdude]

Hi, apologies but i don't really know what im doing with microsoft access anymore.

i have two tables, containing only customer numbers named ""NEWTBD" and "Done".

both contain a column named "PAS Number" which is the customer number and a column named "Primary" (this is for the primary key as the customer number can appear more than once in a single table) which is just an autonumber to give unique id for the primary key.

I want to combine the two tables in a new table which gets the information in "NEWTBD" and deletes all the records which are also in "Done" so all i have left is the records which arent duplicated.

the table "NEWTBD" is a list of all customers which need to be "DONE" and the table "Done" is the list of all the customers which have been done.

All i want is a list of what is left to be done wants the two tables are compared.

any hints, tips or advice in regards on how to set this up would be much appreciated.

thanks

 

[SiGill]

You'll need to do a query taking both tables. Link the PAS Numbers and include everything from "NEWTBD" table.

Take the "PAS Number "and "Primary" items from the "NEWTBD" table and just the "PAS number" from the "Done" table.

In the criteria under "PAS Number" from the "Done" table put Is Null Stick in your totals and change it from Group By to Where.

Run it and you should be left with just what is left to be done.

Hope this makes sense.