Query To List Max Values

Quote: Originally Posted by ansentry Have a look at the attached sample.

Hi John,

I am new to this site. I can't seem to find where the attachment being referred to is. I have a similar question. Basically, I have this data:


Parcel No. ......Soil Type......Area
001-001 flathead 75
001-001 whitefish 33
001-001 kiwanis 45
001-002 kiwanis 22
001-002 flathead 33
001-002 chamokane 74
002-005 flathead 20
002-005 kiwanis 53
002-005 chamokane 27

The desired result is:

Parcel No. Soil Type Area
001-001 flathead 75
001-002 chamokane 74
002-005 kiwanis 53

Can you please help me? Thanks.