Report Subtotals 1

[Jean9]

The report in question has two group headers CO_DESC and NM. In the detail is a textbox whose control source is:
=Round(([HRS]*([RT]/60)),2)
Name: EMPTOT

There is no group footer for NM.
In the CO_DESC footer I need a SUM([EMPTOT]) to work. When I add a textbox to the footer and set its control source to =SUM([EMPTOT]) where the running sum property is set to no, and run the report, the EMPTOT prompt comes up as though this field is unrecognized.

I have another field in the CO_DESC footer: =SUM([HRS]). This one works fine. [HRS] is a field in the underlying datasource. This one's properties is set just the same way as the textbox I added except that the SUM([EMPTOT]) is formatted Currency with 2 decimal places.

What am I missing because I'm going to need a grand total in the report footer, too.

Thanks in advance for any help,
J9

 

[dhookom]

You can't aggregate controls from one section of a report to another.

Try use a control source of:
=Sum( Round(([HRS]*([RT]/60)),2) )
This assumes both HRS and RT are fields in your report's record source.



Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Jean9]

This will work even though both HRS and RT in the detail vary from one detail record to the next?
J9

 

[dhookom]

Do you think I would lie to you ;-) Take one minute and try it.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]