Retaining only highest value record in table

[Curry]

Hi All,

I have a table that has multiple records that are basically duplicates that differ in one field only. I want to get rid of all duplicates leaving 1 record which is the one with the highest value in this field. Can this be done with a query? or do I need to use VBA code to generate this result.

Thanks

 

[John Big Booty]

See my answer here.

Please avoid double posting.