Summing Checkboxes

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Just curious -- why is it that when I sum up check boxes on a record,
the value in the query is Yes/No (even though I can click on the value
and see the total.) Even when I try an Abs on it, I get a Yes/No. Is
there a way around this?

Thanks
 
Yes/No fields store either -1 or 0. What you see on your screen or in your
reports will depend on various properties of fields and/or controls.
 
Just to reinforce Duane's sage response,
any numeric field formatted to "Yes/No"
will display "Yes" for any non-zero value,
and "No" for a zero value.

Examples from the Immediate pane in the
Debug Window:


?Format(2431,"Yes/No")
Yes
?Format(0,"Yes/No")
No
?Format(-2431,"Yes/No")
Yes
?Format(2431.9,"Yes/No")
Yes
?Format(CDec(2431.99),"Yes/No")
Yes
 
Back
Top