>> >>select sum(amount) as [total], >> member_ref, >> description >>from payments >>where description like '%Test%' >>group by member_ref,description >> >>>>
> > select max(total), ; > member_ref ; > from ( ; > select sum(amount) as Total, ; > member_ref, ; > description ; > from payments ; > where description like '%Test%' ; > group by member_ref, description ; > ) X ; > group by 2 >Thanks Gregory