Validation Rule question. Positive becomes negative

  • Thread starter Thread starter MMC
  • Start date Start date
M

MMC

I have a validation rule that says 0=No, 1=Yes. On the form, I made it into a
checkbox. Everything seems fine except that it when I do a query or when I
actually look at the table, 1 (for yes) shows up as -1. What am I doing
wrong? I can't have a negative value to do analysis.

Thanks
 
I have a validation rule that says 0=No, 1=Yes. On the form, I made it into a
checkbox. Everything seems fine except that it when I do a query or when I
actually look at the table, 1 (for yes) shows up as -1. What am I doing
wrong? I can't have a negative value to do analysis.

Thanks
Click to expand...

Regarding: I have a validation rule that says 0=No, 1=Yes
In Access Yes is -1, not 1.
A check box has a value of either 0 (for False or No) or -1 (for True
or Yes).
If you are wanting to get a positive value from -1 (Yes) you would
need to use an expression.
In a query
NewColumn:Abs([CheckBoxName])

To count how many records are Yes in one field
CountYesses:Abs(Sum([CheckBoxField]))
 
Back
Top