Help with an expression, please.

[Sue]

I have a report which in which I'm grouping my fields by result. There are a
number of check boxes which may apply to each grouping. I want a group
footer which will tally the number of responses checked.

So far I've come up with this expression:

=Count([screened?]=Yes)

Obviously I don't know what I'm doing. Can you please help?

Thanks.

 

[Guest]

You are basically asking Access the wrong question. When values are counted,
they are counted. Counts tally every non-null value. Yes is non-null and No
is non-null. I generally use syntax like:
=Sum(Abs([screened?]=Yes))

 

[Sue]

Immensely helpful, Duane - thank you.

You are basically asking Access the wrong question. When values are
counted,
they are counted. Counts tally every non-null value. Yes is non-null and
No
is non-null. I generally use syntax like:
=Sum(Abs([screened?]=Yes))
--
Duane Hookom
Microsoft Access MVP

I have a report which in which I'm grouping my fields by result. There
are a
number of check boxes which may apply to each grouping. I want a group
footer which will tally the number of responses checked.

So far I've come up with this expression:

=Count([screened?]=Yes)

Obviously I don't know what I'm doing. Can you please help?

Thanks.