report sums

[Manaz]

Hi i have a report that displays the total cost of repairs for individual automatic doors. The total cost is retrieved through a sumation query and displayed via the report.

The repair costs are broken down into five categories; mechanical, service, damage, electrical and retro fit

I am trying to sum the cost for each of the doors on the report. For example if door 3 has had 2000 and door 4 has had 450 spent on it, both under the mechanical category i want to display the total at the bottom.

I have tried using =Sum([SumOfMechanical]) but when i run the report i come up with an error.

I have attatched a copy of the report layout which may help you understand what i am trying to say.

Any help would be greatly appreciated

 

[llkhoutx]

Your =Sum([SumOfMechanical]) must not be in the detail section of the report, but in some group footer or the page footer or the report footer.

This assumes that [SumOfMechanical] is a control in the detail section of your report.

I've occassionally encountered problems when the Control Name and Control Source being the same. Ordinarily summing works very well in report footer section.