How can you show SUBTOTALS?

[Scott]

How can you show SUBTOTALS in the same column as the data, NOT in a
separate column?

I need to SUBTOTAL in the same column as one of the the data columns,
like the subtotals 700 and 800 under Field 3 below (I really have 21
columns). Also I must show one blank row after each resulting group:

Field1 Field2 Field3 Field4
entry1 data2.1 100 data4.1
entry2 data2.2 400 data4.2
entry3 data2.3 200 data4.3
700
[B L A N K R O W H E R E]
entry4 data2.4 500 data4.4
entry5 data2.5 300 data4.5
800
[B L A N K R O W H E R E]

How can you do this?

[Bill Karwin]

Re: How can you show SUBTOTALS?

Scott wrote:[color=blue]
> How can you show SUBTOTALS in the same column as the data, NOT in a
> separate column?[/color]

The closest thing I can find is the GROUP BY ... WITH ROLLUP feature,
implemented in MySQL 4.1.1.

http://dev.mysql.com/doc/mysql/en/GROUP-BY-Modifiers.html

Bill K.

[Scott]

Re: How can you show SUBTOTALS?

BILL,
Thank you VERY MUCH!!!
Your help is MOST appreciated.
Scott


Bill Karwin <bill@karwin.co m> wrote in message news:<cetuir04q i@enews1.newsgu y.com>...[color=blue]
> Scott wrote:[color=green]
> > How can you show SUBTOTALS in the same column as the data, NOT in a
> > separate column?[/color]
>
> The closest thing I can find is the GROUP BY ... WITH ROLLUP feature,
> implemented in MySQL 4.1.1.
>
> http://dev.mysql.com/doc/mysql/en/GR...Modifiers.html
>
> Bill K.[/color]