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.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "RemoveDuplicates.mdb" which illustrates how to do this. You
can find it here:
http://www.rogersaccesslibrary.com/f...ts.asp?TID=285

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"zyus" <(E-Mail Removed)> wrote in message
news:45355B10-3F29-49B5-B884-(E-Mail Removed)...
> 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.
>