Highest Value of a Count Field

[simon4amiee]

Hi chats I have 4 columns

PostCode
District
District Name
Count of Postcodes = Count(Left([hull_PostCode.PostCode],4))


Now some Postcodes display 4 lines as they cover 4 Districts, my questions is I only want to show the highest Count per postcode and disregard the rest, Ive tried many variations of the Max function but am a little stuck.

 

[pr2-eugin]

Could you please give some examples of the problem? I am unable to follow your requirement.