conditional count function

B

Bhagya

can I do =Count([Q6=1]) ?
How do I write a statement to count all answers to Q6 where option=1 in a
report?
Please help!
TIA.
 
F

fredg

can I do =Count([Q6=1]) ?
How do I write a statement to count all answers to Q6 where option=1 in a
report?
Please help!
TIA.
Click to expand...

You wish to determine the number or times field [Q6] equals 1?
In an unbound control:

=Abs(Sum([Q6] = 1))

([Q6] = 1) is evaluated as either True or False (-1 or 0)
Sum() adds the -1's and 0's.
Abs() returns the positive value.
 
Top