Grand totals on reports

[Lynne]

I have a report which is grouped by nominal code. The details section are
set not to print out, so I'm just using the nominal footer. I have however
included another field in the nominal footer being budget_this_period, so
this all just prints out on one line.

What I'm trying to achieve is in the report footer section to have a grand
total of budget this period. I've tried using =sum([budget_this_period])
where this relates directly to the field, but it's calculating the grand
total of all the records which are hidden in the details section, and I just
need it to be a total of budgets - i.e. there's only one budget per nominal
code.

Please can anyone help?

Thanks very much

 

[Allen Browne]

Use a running sum to accumulate the values throughout the report.

Add another text box to the group footer, and set these properties:
Control Source: budget_this_period
Running Sum: Over All
Format: Currency
Visible: No
Name: txtBudgetRS

That will collect the value of the budget for each period.

In the report footer you can then place a text box:
Control Source: =[txtBudgetRS]
Format: Currency

 

[Lynne]

Thanks very much - works a treat!

Use a running sum to accumulate the values throughout the report.

Add another text box to the group footer, and set these properties:
Control Source: budget_this_period
Running Sum: Over All
Format: Currency
Visible: No
Name: txtBudgetRS

That will collect the value of the budget for each period.

In the report footer you can then place a text box:
Control Source: =[txtBudgetRS]
Format: Currency

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

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

I have a report which is grouped by nominal code. The details section are
set not to print out, so I'm just using the nominal footer. I have
however
included another field in the nominal footer being budget_this_period, so
this all just prints out on one line.

What I'm trying to achieve is in the report footer section to have a grand
total of budget this period. I've tried using =sum([budget_this_period])
where this relates directly to the field, but it's calculating the grand
total of all the records which are hidden in the details section, and I
just
need it to be a total of budgets - i.e. there's only one budget per
nominal
code.

Please can anyone help?

Thanks very much