Semi-Duplicate Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get just the record with the newest date field for the same account number field, but not all the rest of the fields are identical? I have multiple copies of the same table being updated by different people. Each enter the date the update was done. I need to pull only the newest dates. The other tables have the same record but not all the field match so I get duplicates. I only want the records with the newest dates. How do I get rid of the other records?
 
The answer is probably using an Update query to update the "master" record,
then a delete query to remove the "duplicate".

The update would be based on keeping the record with the newest date, then
the delete based on those records with any date prior to that.

Some VBA may be needed to completely automate the process.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

LeightonS said:
How do I get just the record with the newest date field for the same
Click to expand...
account number field, but not all the rest of the fields are identical? I
have multiple copies of the same table being updated by different people.
Each enter the date the update was done. I need to pull only the newest
dates. The other tables have the same record but not all the field match so
I get duplicates. I only want the records with the newest dates. How do I
get rid of the other records?
 
Back
Top