>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