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.
