Counting Check Boxes

  • Thread starter Thread starter Stewart
  • Start date Start date
S

Stewart

I've created a query to Sum all of the checkboxes in a table.
When the query runs, it shows 'Yes' instead of the amount of checkboxes that
are checked.
When I run the query by itself, I can click on the 'Yes' and get the number
(eg -64, because there are 64 boxes click yes in that field) But I need to
display the totals in a report. Does anyone what I have to do to return the
value I'm looking for?

Any and all help is appreciated.
 
I'm not sure since if I set up a query on a check box field and do a sum it
returns the negative value (as you want).

Have you tried setting up a query just with a single field (which is a
checkbox) and summing that. If it works, you know the problem is with the
query you can't get to work; if it doesn't work then you know its a more
global problem. Not a solution - more helping to know where to look in
greater detail..

HTH
 
Stewart said:
I've created a query to Sum all of the checkboxes in a table.
When the query runs, it shows 'Yes' instead of the amount of checkboxes that
are checked.
When I run the query by itself, I can click on the 'Yes' and get the number
(eg -64, because there are 64 boxes click yes in that field) But I need to
display the totals in a report. Does anyone what I have to do to return the
value I'm looking for?
Click to expand...
Hi Stewart,

The only thing I could think of was that
maybe you had set the format of the
textbox on the report for your sum
to "Yes/No"?

Open the Properties of your textbox
on your report for this field and verify
that you have *not* set the Format property
to "Yes/No."

Any non-zero value will be "formatted"
to "Yes" if the Format property is set to
"Yes/No"

Good luck,

Gary Walter
 
Back
Top