conditional count function

[Guest]

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.

 

[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.

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.