Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete duplicate records, except if...

Status
Not open for further replies.
Jorge Junior

Jorge Junior

Programmer
Mar 12, 2024
1
BR
Hi!
Can someone help me with this?
I know how to get Approach to delete duplicate records based on the fields 1-4.
How do I make it understand that the duplicate record with X is the one that must be kept, unless it's a duplicate; in this case, the duplicate X must also be deleted?

In this example, Approach would only keep records A and G.

Find_and_delete_duplicated_records_2_pzcumq.png
 
Status
Not open for further replies.

Similar threads

schlossy
  • Locked
  • Question
Un hide records
Replies
0
Views
144
schlossy
schlossy
president06
  • Locked
  • Question
Lotus Approach 97 copying records
Replies
0
Views
71
president06
president06
philyour
  • Locked
  • Question
Lotus Approach Locking Records
Replies
0
Views
111
philyour
philyour
maywat
  • Locked
  • Question
formula in lotus approach (enter from another field, if current field
Replies
2
Views
160
PeVadeBo
PeVadeBo
frattonuk
  • Locked
  • Question
Closed records
Replies
1
Views
95
suesloan
suesloan

Part and Inventory Search

Sponsor

Back
Top