Z
zyus
In my Find Duplicates query i'm able to extract duplicate info on the acno
field as per below sample
ref acno mthinarrears
a 12345 5
b 12345 2
c 54321 2
d 54321 1
e 78945 6
f 78945 2
I want to delete duplicate record where the mthinarrears is lower than the
previous data. In my sample data the deleted data will be b,d and f.
How to do this in a query or any other method.
field as per below sample
ref acno mthinarrears
a 12345 5
b 12345 2
c 54321 2
d 54321 1
e 78945 6
f 78945 2
I want to delete duplicate record where the mthinarrears is lower than the
previous data. In my sample data the deleted data will be b,d and f.
How to do this in a query or any other method.