>SELECT agent+company as MyField,SUM(sales),MAX(sales) FROM sales;
>GROUP BY MyField
>
>Looks like you are not get a very fast reponse. I just ran this query (VFP6) on one of my tables and got what seems to be a valid response. For the couple rows I checked the sum() and max() values were correct.
>
>HTH,
>
>kevin

Thanks for the response Kevin. I was able to show the group just how quickly you can get help from the UT............Rich