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.
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.