Help using conditional count in form header

F

Floyd Forbes

Is it possible to have a textbox in the form header to count
the number of a conditional textbox in detail section? I get #Error.

Thanks
 
O

Ofer Cohen

What did you try that you get an error?

Try:
=Sum(IIf(YourConditionIsTrue,1,0))

So, the IIf will return 1 if the condition s met, and the Sum will add up
all the 1'ns
 
Top