conditional count function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top