1=Yes 0=No in Validation rule. 1=Yes become -1=Yes

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
 
J

Jerry Whittle

-1 = Yes in Access. Strange indeed.

One trick is to use the ABS (AKA Absolute Value) function. It turns negative
numbers into positive. Therefore both ABS(1) and ABS(-1) = 1 .
 
Top