How to update a specific field from a Find Duplicates querie

M

MikeN

I have to update 1 table that has multiple duplications. If i search for
duplicate on Field1, Field2, and Field3 all matching, i receive many
duplicates where Field4 and Field 5 are different and/or Null. What do i
need to do to the query so that Field4 and Field5 will be automatically
updated when the duplicate is found?

Current:
Field1 Field2 Field3 Field4 Field5
Mike Smith 1234 KEEP
Mike Smith 1234 DELETE 9012

Desire result:
Field1 Field2 Field3 Field4 Field5
Mike Smith 1234 KEEP 9012
(and the other row deleted)

is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3 csv file to one & linking to find unique rows 0
Calculate Null Field 2
add cell in table 6
Create Field in table and define it's position 1
Duplicates in some fields, but not others 0
Shift several columns in table 4
figuring averages in Access 2
MS ACCESS query 5

Top