Having trouble Summing a unbound text box on subform 1

[DougP]

Having trouble Summing a unbound text box on subform

If the Overtime check box (a “Yes/No” field) is checked I want to add those hours.
I have this in the textbox:
Name of text box: txtOTHours
Control source: =IIf([overtime]=True,[Hours],0)
This works great, it shows the hours if someone checked the overtime box and nothing if the check box is empty.

The issue is Summing in the footer, I put a textbox in the footer with this:
name: SumOTHours
control source: =Sum([txtOTHours])

I get #Error in all the textboxes in the footer.
The textboxes in the footer that have bound fields Sum just fine.
Is there any easy fix to this?


DougP

 

[PHV]

you may try this:
control source: =Sum(IIf([overtime]=True,[Hours],0))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886