Counting True Checkbox on Form

SpiritedAway

Registered User.
Local time
Today, 12:16
Joined
Sep 17, 2009
Messages
97
Hi.

I have a continuous form with a bound checkbox [VAT] - I have an unbound textbox which I want to use to count how many checkboxes that are TRUE.

I'm trying to use the =Count function but getting invalid syntax error messages.

Could anyone advise the correct syntax to use as the control source for the textbox.

Thanks for your help.

Using A2007
 
Something like this:
Code:
=Count(IIF(Nz([[COLOR=Red]Field[/COLOR]], 0) = -1, 1, Null))
 
Brilliant!! - thanks once again vbaInet for your invaluable help!
 

Users who are viewing this thread

Back
Top Bottom