>>Based on your and Freds response, it appears Group by is primarially usefull when there is a summation of som sort involved. Would you agree? It appears that if there are fields in the select that cannot be summed there is an error. Such as SELECT * FROM ORDERS GROUP BY DATE. I think I am having difficulty because I think of it as a group in the report designer.
>
>I think what you're looking for is ORDER BY.
>
>Tamar

Yes, sort of. I was trying to understand the difference between ORDER BY which sets up a report for Groups, and GROUP BY which would seem to be related. But I understand now that they are not.
- Don