Unanswered: Report Footer Totals for independent fields
I have this report with calculation fields in it and i want the som of this fields in the footer. Sum([calcfield]) doens't workt even if this is the wright name of the field. The calculation happens in the report and not in the query.
You will have to put your equation in the query. That is the only way I got it to work. I used your data that you supplied. I created an equation in the query called Total and then the report was able to do the sum at the bottom against the Total field.
I think the reason it did not sum before is beacue the field is an equation itself, not actual data.