Re: SQL detail and summary at same time?

[Bill <bubbzbill@xxxxxxxxx>]

You slightly misunderstood my answer.  If you indeed want your output as 
your first example, you just can't do it - that is the output of a 
report writer.  SQL is only a data access program, it doesn't do what 
you want.

Bill


Antonio Fernandez-Vicenti wrote:
> Bill, thanks for your answer, but I think it's not what I meant:
> I'd like to get something like this
>         01          AA        field3
>         01          AA        field3
>         01          AA        field3
>           Subtotal01AA   xxxxx
>         01          BB        field3
>         01          BB        field3
>         01          BB        field3
>           Subtotal01BB   yyyyy
>         05          XX       field3
>         05          XX       field3
>         05          XX       field3
>           Subtotal05XX  zzzzzz
>            Final TOTAL   TTTT
>
> with Subtotals intermixed with detail lines, plus a final Grand Total
>
> whereas the code you suggested  I think will yield something like
>
>         01          AA        field3    xxxxx  
>         01          AA        field3    xxxxx
>         01          AA        field3    xxxxx
>         01          BB        field3    yyyyy
>         01          BB        field3    yyyyy
>         01          BB        field3    yyyyy
>         05          XX       field3     zzzzz
>         05          XX       field3     zzzzz
>         05          XX       field3     zzzzz
> and without the Final Total.
>
> Am I wrong or did I misunderstand your suggestion?
> Thanks in any case!