Totalling yes or No's

B

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 [email protected]
 
S

SteveM

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

Steve
 
C

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 [email protected]
Click to expand...

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!
 
Top