Count not null check boxes

[Guest]

I have a report that I must count the number of check boxes in the on
position or the is not null. I used the "= Count ([Injury])" below the
footer but it counts all the check boxes even if they have not been checked.

 

[tina]

try

=Sum(Abs([Injury])

hth

 

[tina]

oops! make that

=Sum(Abs([Injury]))

try

=Sum(Abs([Injury])

hth

I have a report that I must count the number of check boxes in the on
position or the is not null. I used the "= Count ([Injury])" below the
footer but it counts all the check boxes even if they have not been checked.

 

[Brendan Reynolds]

An unbound checkbox can be Null, but a Boolean (Yes/No) field in a JET
database (MDB) or a check box bound to such a field is never Null, it is
either True or False.

See Tina's post elsewhere in this thread for a solution.

 

[Guest]

Thanks

oops! make that

=Sum(Abs([Injury]))

try

=Sum(Abs([Injury])

hth

I have a report that I must count the number of check boxes in the on
position or the is not null. I used the "= Count ([Injury])" below the
footer but it counts all the check boxes even if they have not been checked.

 

[tina]

you're welcome

Thanks

oops! make that

=Sum(Abs([Injury]))

try

=Sum(Abs([Injury])

hth


I have a report that I must count the number of check boxes in the on
position or the is not null. I used the "= Count ([Injury])" below the
footer but it counts all the check boxes even if they have not been
checked.