Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group Total of Calculated Field with Running Sum in Group Header - S.O.S. (((

Status
Not open for further replies.

powerniso

Programmer
Jul 14, 2015
3
AZ
Hi everyone!
And please help.
OdalardaKalanlar_optc0p.jpg

This is my report. The red circle below is the calculated field ([TotalDaysStayed]) with running sum. It shows up the correct number as sums the last column ([DaysStayed]).
The field [DaysStayed] is calculated as: [DateLast]-[DateFirst]+1 (interval including both start and end dates)
But, ... when I try to show up the total (textbox named - [GTotalOfDays]) of the last column at the group header (the blue circles), it shows up the sum of the first two group headers.
I tried :
- [GTotalOfDays] control source = [TotalDaysStayed] -> Result: [GTotalOfDays]= first value of the [TotalDaysStayed] which is 7 (not correct, must show 15)
- [GTotalOfDays] Running Sum property set to Over Group, control source = [TotalDaysStayed] -> Result: as on image

How can I sum up the [DaysStayed] field in Group Header for a group?
Thanks thanks and again thanks if you try to help me.
 
Thanks for your reply,

But, I forgot to mention that:

1st - the fields [DateFirst] and [DateLast] are both calculated fields
2nd - The problem occurs when adding the total field to Group Header, if I add the Total Field to group footer, there is no problem.

Thanks.
 
Whatever the calculation of the fields might be, you should be able to use =Sum([ your expression here ]) in group and report headers and footers. This will not work in page sections.

Duane
Hook'D on Access
MS Access MVP
 
Oops, "SUM" function not works on header and footer on calculated fields (unbound - bound to function rather than a field on a table or query). But I am not interested on using functions, but why group total shows correct on footer, but wrong on header. Any help appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top