I have a query to extract some data. Two columns include a setup date
(setupdt) and a completed data (compdt).

I would like the data grouped to get sub-totals but shown in different
orders/ I would like the compdt with the newest first i.e. desc order and
setup date with the oldest first i.e. asc order



I have tried various combinations of



SELECT . WHERE . GROUP BY compdt DESC, setupdt ASC



Or I have GROUP BY with ORDER BY mixed with various combinations. I have yet
to get the correct results. I am using 5.0.45 under WAMP.



Can someone tell me if what I want is possible?



Kerry