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
|
|||
|
|||
Finding Duplicate Records
I have a table that contains the following information:
Auto ID, PersonName, EventName, EventDate PersonName, EventName, and EventDate are not unique. There are thousands of records. I would like to find duplicate records that repeat PersonName and EventName. It does not matter if the date is the same or not. Ultimately I wish to delete the one with the most current date, but I also want to know what is being deleted. A log would be fine. I assume this can be done. Can someone help me create the query to do so? |
#2
|
|||
|
|||
Finding Duplicate Records
On Mon, 12 Jul 2004 18:07:30 -0700,
wrote: I have a table that contains the following information: Auto ID, PersonName, EventName, EventDate PersonName, EventName, and EventDate are not unique. There are thousands of records. I would like to find duplicate records that repeat PersonName and EventName. It does not matter if the date is the same or not. Ultimately I wish to delete the one with the most current date, but I also want to know what is being deleted. A log would be fine. I assume this can be done. Can someone help me create the query to do so? The Query Wizard will do so: create a new query and select the Find Duplicates wizard. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Finding duplicate names | Matt in AZ | General Discussion | 1 | June 14th, 2004 08:18 PM |
How to identify duplicate records and count them | vishal | Worksheet Functions | 1 | June 6th, 2004 06:33 PM |
duplicate records, how to identify and count | Andy B | Worksheet Functions | 2 | May 26th, 2004 02:57 PM |
Duplicate Records | Jas | Worksheet Functions | 4 | January 28th, 2004 09:00 PM |
finding duplicate records | fazlici | Worksheet Functions | 3 | December 23rd, 2003 08:28 PM |