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