On Thu, 09 Mar 2006 21:45:19 GMT, ILoveAccess via AccessMonster.com
wrote:
How do you do this? Please help. thank you!
A Yes/No field already has a numeric value, either -1 for Yes or 0 for
No.
So you can count check boxes by adding their -1 or 0 value.
=Abs(Sum([CheckBoxName])) will give you the number of Yes's.
= Sum([CheckBoxName]+1) will give the number of No's
You cannot assign any other value to a Yes/No field.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail