Totalling yes or No's

[belczyk]

Can someone email me a small sample database that reflects a yes or
no
answer to a group. like if i want to know how many 35, 36, 40 yr
olds
are married, which is answered by a yes or no.

Can some one help


Please


Email (e-mail address removed)

 

[Guest]

Count Yes/No like this in your query:
IIf(FieldName = Yes,1,0)
Then set 'View Totals' and set the column to Sum.

Steve

 

[Allen Browne]

Answered in one of the other groups where you posted this question.

 

[cynthia]

Can someone email me a small sample database that reflects a yes or
no
answer to a group. like if i want to know how many 35, 36, 40 yr
olds
are married, which is answered by a yes or no.

Can some one help

Please

Email (e-mail address removed)

At least someone answered your query on this question. When I asked, I
got no response, however, I did find an
answers:

=Sum([Field Name])*-1

Very simple and works like a charm. Nowhere does it tell you that Y=
-1!