Skip to content

Summing a calculated field on a report

How to total a calculated field on a report.

Q:  Marie H. needs a total in a report group footer, based on a calculated field in the report detail section.  =Sum([txtWeekTotal]) doesn’t work – how can this field be totaled?

A:  You can’t total a textbox, but you can total the text box’s control source, so in this case it would be something like =Sum([MonAmt] + [TuesAmt] + [WedsAmt] + [ThurAmt] + [FriAmt]).  Another possibility is to create the calculated field in the report’s record source query or SQL statement, so it is a field in the report, and can be totaled as =Sum([WeekTotal]).

About this author