Duplicate Query Without Highest Value

[laman]

I am trying to run a Query with code to return duplicates which do not include the duplicate with the highest value in a specific field. For example if I have 3 dupicate records with values in Field3 of 40,30 and 20, I want the query to return only the records with the lower values (30 and 20).
I hope it is explained good enough.

Please Help!

 

[jgoodman00]

How about creating a query which finds the maximum for each record. Then join this to your find duplicates query. In the criteria field for your Field3 set it to <> [QueryName].[MaxField3]

This should do what you need... James Goodman