Hi,

I have to correct the last part of what I wrote here:

> If you don't want to use a reporting tool, use two
> separate queries.

Obviously, I should have said: use only one query for the
ordered and grouped data and calculate the sums yourself
in the client software. Which is what reporting tools do.

Cheers,
Tobias