Software

Ask something
Discussion Locked

Access 2000 duplicate records

0 helpful
7 replies

by dliby

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Access 2000 table that has the following fields: Name, Date, Time, Address, and a few more fields. There are multiple records for the same name. The date and time for these records is different. I need to create a query or another tablewith each record not duplicating the name field and having only the latest date and time

7 replies

by dklippert

Choose Queries on Objects bar.
Click on New on the toolbar.
Look at the Find Duplicates Query Wizard

by dliby

I need to delete the duplicate name records and keep only the record with the latest date and time for each name.

by dklippert

Also look at the Delete Query.
Create a Query based on the Duplicate Wizard.
In Design view go to Query on the menu and choose a Delete Query.
(Copy your original for safety)

by rkuhn040172

Write 2 queries.

The first one displays all records in your original table with a maximum value in the date field and makes a new table.

The second query deletes all records from the orginal table that have the same name but a "is null" value in the date field in the second table.

Basically, you are selecting and creating a table of all records with the highest date and then creating a unmatched query to delete the remaining records that match by name but not date.

This discussion is closed to new replies.