Sending non duplicates from two tables to a new table

's Computer Specifications

I have a customer list and a non customer list. These list contain many
duplicates. How can I search for the duplicates in the two files and have the
noncustomers remaining after the duplicate search be added to a new
table/file?

's Computer Specifications

Why not combine them into one table and add a checkbox for the customers?

--
Rick B

"Hilary" <(E-Mail Removed)> wrote in message
news:E1ECAD0D-7DF3-4D65-BE43-(E-Mail Removed)...
> I have a customer list and a non customer list. These list contain many
> duplicates. How can I search for the duplicates in the two files and have
the
> noncustomers remaining after the duplicate search be added to a new
> table/file?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy selected records from two tables to two new tables	alhotch	Microsoft Access	2	1st Feb 2010 01:03 AM
Condensing a list with duplicates to a list with non-duplicates	Nuclear	Microsoft Excel Worksheet Functions	2	29th Jul 2008 08:03 PM
Appending data from two tables to two tables in Access 2000.	=?Utf-8?B?REJlbmVkaWN0?=	Microsoft Access	1	16th Sep 2006 10:03 AM
Duplicates OK, Non-Duplicates - Red flag	kerry.kulakowski@converge.com	Microsoft Access	0	14th Aug 2006 07:29 PM
How to take two tables and remove all non duplicates	rr1990	Microsoft Access Getting Started	1	11th Feb 2005 11:46 PM