|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 7th, 2005, 06:17 PM
|
|||
|
|||
How can I creat an Access query to find duplicate records?
I have a mailing list of 10,000 records and I want to find any duplicate
addresses so we don't mail them twice. Can this be done with an Access query? I am using Access 2003 on XP professional. 
|
|
#2
April 7th, 2005, 06:34 PM
|
|||
|
|||
|
Use the query wizard and select "find duplicates query"
Rick B "KH" wrote in message news  I have a mailing list of 10,000 records and I want to find any duplicate addresses so we don't mail them twice. Can this be done with an Access query? I am using Access 2003 on XP professional.
|
|
#3
April 8th, 2005, 12:35 AM
|
|||
|
|||
|
Create a query that includes the fields that may be duplicated. Change the
Unique Values property to "Yes". You should get only one of each. Jeff Boyce Access MVP "KH" wrote in message news I have a mailing list of 10,000 records and I want to find any duplicate addresses so we don't mail them twice. Can this be done with an Access query? I am using Access 2003 on XP professional.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Access Update Query Not Working From ADO | Barry-Jon | Running & Setting Up Queries | 3 | March 18th, 2005 08:42 PM |
| What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
| Can't get Access to run a query with a time field | RonSLevy | Running & Setting Up Queries | 3 | September 29th, 2004 04:04 PM |
| Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
Linear Mode
