ERROR in Sum Formula Text Bos

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a continuous form with the following fields in the Detail:

Name Use? Size1 Size 2
and a calculated field Size3 with this logic:
if Use=true then Size3 = Size1 + Size2, else 0.

"Use" is just a check box and Size3 gets calculated in the records just fine.
ie it shows the S1+S2 when Use is checked and "0" when it's not checked.

The problem is that in the Form Header, I have some calculated fields:
Sum(Size1); Sum(Size2); Sum(Size3)

Size1 & Size2 sum up just fine, BUT when I try to add the Sum(Size3) box,
all 3 show Errors.... If I delete the Sum(Size3) Box, the errors in the other
Sum Boxes go away.

Any idea why this is happening?
 
Hi, Mike.

I'm not sure why it would cause an error in the first two fields, but Sum
can only total a real field, not a calculated one. Replace = Sum([Size3])
with:

=Sum(IIf([Use]=True,[Size1]+[Size2],0))

Hope that helps.
Sprinks
 
I'll give it a shot.

Thanks!

Sprinks said:
Hi, Mike.

I'm not sure why it would cause an error in the first two fields, but Sum
can only total a real field, not a calculated one. Replace = Sum([Size3])
with:

=Sum(IIf([Use]=True,[Size1]+[Size2],0))

Hope that helps.
Sprinks


MikeZz said:
I have a continuous form with the following fields in the Detail:

Name Use? Size1 Size 2
and a calculated field Size3 with this logic:
if Use=true then Size3 = Size1 + Size2, else 0.

"Use" is just a check box and Size3 gets calculated in the records just fine.
ie it shows the S1+S2 when Use is checked and "0" when it's not checked.

The problem is that in the Form Header, I have some calculated fields:
Sum(Size1); Sum(Size2); Sum(Size3)

Size1 & Size2 sum up just fine, BUT when I try to add the Sum(Size3) box,
all 3 show Errors.... If I delete the Sum(Size3) Box, the errors in the other
Sum Boxes go away.

Any idea why this is happening?
Click to expand...
Click to expand...
 
Back
Top