Help with Report Grouping

[Ayo]

If I have 2 sections in a report like this:

Reviewer Header
Vendor Header
Detail
Vendor Footer
Reviewer Footer

with a txtbox in each section. I want the txtbox in the Vendor Footer to
calculate the total for each Vendor and I want the txtbox in the Reviewer
Footer to sum up all the values in the Vendor Footer and put it in the txtbox
of the Reviewer Footer.
Is this possible? If so, how would I do this?
Thank you.

 

[Allen Browne]

You can collect a progressive total with a running sum text box.

Assuming you already have a text box in the Vendor Footer section, named
txtVendorAmount, add anothe text box to the same section, and set these
properties:
Control Source =[txtVendorAmount]
Running Sum Over All
Format Currency
Visible No
Name txtVendorAmountRS
This text box will progressively accumulate the total.

You can now add a text box to your Reviewer Footer section, and set its
Control Source to:
=[txtVendorAmountRS]

 

[Ayo]

Thanks

You can collect a progressive total with a running sum text box.

Assuming you already have a text box in the Vendor Footer section, named
txtVendorAmount, add anothe text box to the same section, and set these
properties:
Control Source =[txtVendorAmount]
Running Sum Over All
Format Currency
Visible No
Name txtVendorAmountRS
This text box will progressively accumulate the total.

You can now add a text box to your Reviewer Footer section, and set its
Control Source to:
=[txtVendorAmountRS]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

If I have 2 sections in a report like this:

Reviewer Header
Vendor Header
Detail
Vendor Footer
Reviewer Footer

with a txtbox in each section. I want the txtbox in the Vendor Footer to
calculate the total for each Vendor and I want the txtbox in the Reviewer
Footer to sum up all the values in the Vendor Footer and put it in the
txtbox
of the Reviewer Footer.
Is this possible? If so, how would I do this?
Thank you.