General discussion

Locked

Access 2000 duplicate records

By dliby ·
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

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2000 duplicate records

by DKlippert In reply to Access 2000 duplicate rec ...

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

Collapse -

Access 2000 duplicate records

by dliby In reply to Access 2000 duplicate rec ...

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

Collapse -

Access 2000 duplicate records

by DKlippert In reply to Access 2000 duplicate rec ...

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)

Collapse -

Access 2000 duplicate records

by dliby In reply to Access 2000 duplicate rec ...

Poster rated this answer

Collapse -

Access 2000 duplicate records

by rkuhn In reply to Access 2000 duplicate rec ...

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.

Collapse -

Access 2000 duplicate records

by dliby In reply to Access 2000 duplicate rec ...

Poster rated this answer

Collapse -

Access 2000 duplicate records

by dliby In reply to Access 2000 duplicate rec ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums