suppress duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using access 2002. Need help with trying to suppress duplicate records
between two tables. One table has 4 million phone numbers and one has 2700
phone
numbers. I'm trying to compare the smaller table to the bigger table and
suppress any phone numbers from the smaller table that are listed in the
bigger table. I don't want to merge them together because I'm using the
smaller table for a mailing. Can anyone help me.
Thanks
 
Kevin,

I'm not very familiar with SQL language, if that's what you wrote in the
first reply. So if you could dumb it down for me I'd appreciate.

The larger file is a file that I will use to compare all other future files.
So I want only numbers in the small table that do not show up in the big
table.

Please let me know what you think.
 
Thanks, Let me give it a try



Kevin3NF said:
In the Access database window, click on queries, then NEW, then Find
Unmatched Query Wizard. This will walk you through the process of finding
records in the small table that are not in the big table

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions
Click to expand...
 
If you are not too familiar with SQL, and even if you are your best bet is
to merge the tables. But simply create an extra column with a number or text
in it to identify which records you want for your mailing and which are not
for mailing. You can then make a query that filters the records by this
identifier in the new column. Use this query for your mailing.

Ian
 
Back
Top