>>Sorry Antonio
>>
>>I updated the message to say can I have the max for each member_ref
>>
>>
>>>Can
>>>

>>>ORDER BY total DESC
>>>

>>>do the trick?
>>>
>>>>Hi
>>>>
>>>>I have
>>>>
>>>>

>>>>
>>>>select sum(amount) as [total],
>>>>		member_ref,
>>>>		description 
>>>>from payments 
>>>>where description like '%Test%' 
>>>>group by member_ref,description 
>>>>
>>>>

>>>>
>>>>how can I select out only the maximum sum amount.
>>>>
>>>>Thanks
>>>>
>>>>Nick
>
>I'm missing something here, if you select the sum(amount) for each member_ref grouped by member_ref, then isn't the sum of the total for each member_ref, therefore, the max?

Hi John

no because I also have several possible description groups.
So I want the Maximum amount amongst the description groups sums for each member.

Thanks

Nick