removing duplicates with lower value.

[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]

With Your query in Design view click the Sigma (Σ {Total, Sum}) button and select Max for that field, in the design grid.

 

[Curry]

Yes..of course....Think I was trying too hard...Thanks for your help.