Counting to zero

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

Guest

I have a problem regarding how to count members in a membership database. I
use the COUNT function, and limit the rows counted by the condition of a
yes/no checkbox, and then show the result in a "overwiev" form. Since this
checkbox represents whether or not the particlur member have payed, a both
all yes and all no situation can occour.
My problem is that when I try to count something that aren´t there (number
of non paying members in the all yes case), the result is litterally nothing!
I have tried with nz, IsNull, IsEmpty, IsMissing and almost everything, but I
just can´t get the damn thing to show zero. My query just shows the
headlines, and nothing...
Please help since this is very frustrating!
Rasmus Kjeldsen
 
Since a Yes/No checkbox is stored as a 0 (No) and not-zero (Yes), you can
SUM, rather than Count. The Sum([YourCheckBox]) or the absolute value of
the sum (i.e. Abs(Sum([YourCheckBox]))), "counts" the number of yes
checkboxes.

Or have you tried using the selection criterion for the checkbox and
counting the row ID?

(all this really depends on how your data is structured, and I don't have a
very clear picture of that.)
 
Back
Top