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 Mike Lewis 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. (((
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.- powerniso
- Post #5
- Forum: Microsoft: Access Forms
-
Group Total of Calculated Field with Running Sum in Group Header - S.O.S. (((
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.- powerniso
- Post #3
- Forum: Microsoft: Access Forms
-
Group Total of Calculated Field with Running Sum in Group Header - S.O.S. (((
Hi everyone! And please help. 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...- powerniso
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
