C
Chris B via AccessMonster.com
I have a from with a sub-form and am trying to display several =sum() totals
in the form and the report footers.
I have tried using =Sum(fieldname) and i have tried =sum(The whole expression)
..
The problem is that only one of the totals are working, i cant get the more
complecated totals to work.
my fields are [normalhrs], [overtimehrs], [totalhrs] and [overtimeamount].
The only =sum() to work is the =sum[expression used to calculate total hrs].
Others give me #ERROR statements
By saying more complecated, some of the expressions have several IIF
statements and some are affected by a check box. they work fine in the form,
its just trying to diplay their =sum() total that is the problem.
I have looked around for similar threads but still have the same problem also
some of them mentioned changing the text box property for Running Sum to true,
I have not been able to find that property anywhere??
Anything that I might be missing?
in the form and the report footers.
I have tried using =Sum(fieldname) and i have tried =sum(The whole expression)
..
The problem is that only one of the totals are working, i cant get the more
complecated totals to work.
my fields are [normalhrs], [overtimehrs], [totalhrs] and [overtimeamount].
The only =sum() to work is the =sum[expression used to calculate total hrs].
Others give me #ERROR statements
By saying more complecated, some of the expressions have several IIF
statements and some are affected by a check box. they work fine in the form,
its just trying to diplay their =sum() total that is the problem.
I have looked around for similar threads but still have the same problem also
some of them mentioned changing the text box property for Running Sum to true,
I have not been able to find that property anywhere??
Anything that I might be missing?