var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MS Access group calculation issue
I am running into a problem when I tried to have a sumation of the groups in an Access report.
the issue is that I have a subtotal field called 'SubTotalCharge' that calculates the each induvidual total usage cost of a unit(group). The Data tab looks like following:
the problem is that each field above is a complex calculation by itself as well.
for example, the [SubPlanCost] is actually:
so when I tried to have a total of 'SubTotalCharge', it wouldn't give that but instead, it asked me for a value for 'SubTotalCharge', which mess me up.
any body has any idea how can I get the correct calculation? or do I need to write code to control this?
a million thanks in advance
You can't sum a calculated control (which is what SubPlanCost is). Your 2 basic options are to recreate the calculation in the Sum function, or put a second hidden control in the detail with the same calculation and its running sum property set appropriately, and refer to that control in the footer.
Thank you so much Paul! I got it!
Happy to help. Welcome to the site by the way.