I am needing to get the total amount on a SalesAmt field for each sales person, and using a SELECT sum statement I am having no problem doing that.

Here is the question: is there also a way to get the smallest amount, and the largest amount as well for each sales person?

Thanks,
Mel Cummings