Can you calc subtotals on a form coming from a subform?

[gg]

On my main contract header form, I have a total field being calculated in the
"Total" field control source =
Dsum("orig_amount-amount_discount","effective_contract_detail","[contract_no]="
&nz([contract_no],0)) for doc_type="OA" however, now I'd like to calculate
several other totals, for my different doc_types (OA, A1, A2, A3...,AR1,
AR2... and CO1, CO2...etc.) and display them all on the main form. There may
be up to 10 totals for the A# type doc_type. The number of A's or AR's or
CO's can increment up to 10). Problem #1), limited number of space on the
main form, problem #2) do I need to do this in a query or VB and not a DSum
in a control source?

Thank you,
gg

 

[BabyATX13 via AccessMonster.com]

Are you using a FORM or a REPORT? You are in Reports/Printing forum

For a report it would look kind of like this.
=Function([report total field]operator[subreport name].Report!Field with
total)
Example:
=Abs([Total2]-[Barcode].Report!TotalB)
I would guess for a form it would look similar only replace “Report!” with
“Form!”

KB

On my main contract header form, I have a total field being calculated in the
"Total" field control source =
Dsum("orig_amount-amount_discount","effective_contract_detail","[contract_no]="
&nz([contract_no],0)) for doc_type="OA" however, now I'd like to calculate
several other totals, for my different doc_types (OA, A1, A2, A3...,AR1,
AR2... and CO1, CO2...etc.) and display them all on the main form. There may
be up to 10 totals for the A# type doc_type. The number of A's or AR's or
CO's can increment up to 10). Problem #1), limited number of space on the
main form, problem #2) do I need to do this in a query or VB and not a DSum
in a control source?

Thank you,
gg

 

[gg]

Are you using a FORM or a REPORT? You are in Reports/Printing forum

For a report it would look kind of like this.
=Function([report total field]operator[subreport name].Report!Field with
total)
Example:
=Abs([Total2]-[Barcode].Report!TotalB)
I would guess for a form it would look similar only replace “Report!†with
“Form!â€

KB

On my main contract header form, I have a total field being calculated in the
"Total" field control source =
Dsum("orig_amount-amount_discount","effective_contract_detail","[contract_no]="
&nz([contract_no],0)) for doc_type="OA" however, now I'd like to calculate
several other totals, for my different doc_types (OA, A1, A2, A3...,AR1,
AR2... and CO1, CO2...etc.) and display them all on the main form. There may
be up to 10 totals for the A# type doc_type. The number of A's or AR's or
CO's can increment up to 10). Problem #1), limited number of space on the
main form, problem #2) do I need to do this in a query or VB and not a DSum
in a control source?

Thank you,
gg

 

[gg]

Oops...I should be in Forms. Thanks for your help!
gg

Are you using a FORM or a REPORT? You are in Reports/Printing forum

For a report it would look kind of like this.
=Function([report total field]operator[subreport name].Report!Field with
total)
Example:
=Abs([Total2]-[Barcode].Report!TotalB)
I would guess for a form it would look similar only replace “Report!†with
“Form!â€

KB

On my main contract header form, I have a total field being calculated in the
"Total" field control source =
Dsum("orig_amount-amount_discount","effective_contract_detail","[contract_no]="
&nz([contract_no],0)) for doc_type="OA" however, now I'd like to calculate
several other totals, for my different doc_types (OA, A1, A2, A3...,AR1,
AR2... and CO1, CO2...etc.) and display them all on the main form. There may
be up to 10 totals for the A# type doc_type. The number of A's or AR's or
CO's can increment up to 10). Problem #1), limited number of space on the
main form, problem #2) do I need to do this in a query or VB and not a DSum
in a control source?

Thank you,
gg