Thanks Tobias,
That is what I figured. I had written some client code for ReportLab
(Python) for grouping and was about to write the code for totaling.
I wanted to make sure that there were not any functions built into
the API that could do it more quickly. Interbase has so many nooks
and crannies that I felt I needed to check.
Thanks again,
Derek Basch


--- In ib-support@y..., "Tobias Giesen" <tobias_subscriber@t...>
wrote:

> 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