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!

Search results for query: *

  1. powerniso

    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.
  2. powerniso

    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.
  3. powerniso

    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...

Part and Inventory Search

Back
Top