How do subtotal of only display field on a foot group, not subtotal of record in the query, only displayed in the foot group. I do need subtotal in a next foot group of all last records for each foot group

I am so sorry, but my english no is good…

In Spanish:

Como hacer subtotales de solo los campos desplados en un pie de grupo, no de los que estan fisicamente en el query, por ejemplo, en el pie de grupo solamente escrivo el ultimo registro del grupo, y necesito en otro pie de grupo la suma de todos los ultimos registros del anterior pie de grupo..

Thank's for any help…

Luis,

I think that you need 'grouping' from what I gather. Group by the field that you want subtotalled, and then put a Total field in the Group break.

-Stephen

Thank you Stephen…

But a need in the same group break subtotal of all field1 and of all last field2 eg:

With (MV)=Multi Valued

In Table:

    Item    Date(MV)  Sales(MV) Existence(MV)

1. —— ——– ——— ————-

    Uno     01 FEB 99         1            20

            02 FEB 99         3            17

            03 FEB 99        10             7

    Dos     01 FEB 99         3            30

            03 FEB 99        15            15

I Need in Report of 01 FEB 99 at 03 FEB 99:

    Item    Total Sales  Existence

1. —— ———– ———

    Uno              14          7

    Dos              18         15

In "Existence" I need put 7,15.. not the sum (44,45…), how do it in Report Designer???

Thank's for your help

___

Luis B.

View this thread on the forum...