New
#1
Find duplicates in Access 2013
Hi all,
At the office we have a data base of about 12000 customers. actually it is 12000 orders. some customer purchased from us several times. We want to send our customers a letter and introduce a new item that they may want.
the actual number of customers is about 8000 and it would cost a lot of money to send out the unneeded 4000 letters. So I am trying to find a way to eliminate the duplicates.
the database has several fields:
order # -- First Name -- Last Name -- Address -- City -- Zip
I could sort the database by address and take out the duplicates 1 by 1 witch will take forever.
I'm hoping someone here knows how to set up a query to do the job.
also, please tell me in plain English how to set it up.
Thanks
Sven