Fuse duplicate records
- Thread starter darrask
- Start date
I began by designing a Find duplicates query with the wizard, which returned records with same [ES Detail] and [ES category] in table ES_Detail. I then added [ES ID] from table ES and converted it into an update query.
[ES ID] in the ES table has to be updated to the corresponding [ES ID] in table ES_Detail that has the earliest [Date created] for those duplicate records.
[ES ID] in the ES table has to be updated to the corresponding [ES ID] in table ES_Detail that has the earliest [Date created] for those duplicate records.
I tried several functions, First, DFirst, DLookup, but I'm having difficulties to specify the criteria part of my DLookUp function (indicated by ??? in the screenshot), mostly my tries lead to type conversion failures.
To post a screenshot I need 10 posts, that's why I split my text, sorry for that.
In effect, such a query, if working, would fuse my duplicate records (hence the title) after I delete the empty ones (another query is ready for that)
In effect, such a query, if working, would fuse my duplicate records (hence the title) after I delete the empty ones (another query is ready for that)
