Sum calculated fields in a report

[gavin31]

The group detail of my report contains all the employees' details - e.g. name, start time, end time and a text box named "hours" that subtracts start time from end time. This is all OK.

In the footer for this group I have a text box named "employeesHours"

The value for employeesHours I want to make a running sum by calculating the sum of all the "hours" text boxes.

It works when I use
=Sum([endTime]-[startTime])

but not when I use
=Sum([hours])

Can I not refer to the calculated control in this way??
Why???
Please help

 

[dhookom]

No, you can't Sum() a control. You can only Sum() an expression comprised of fields from 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]

 

[gavin31]

Ok thanks for confirming that. Bit annoying as I wanted to use the calculated control to go on and calculate further results.

I may now try to do this in the code module as the expressions get very long in a later calculated control.

Gavin

 

[dhookom]

Code in report events designed to create aggregate values is generally not very successful. You are much better off using expressions in control sources.

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]