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 .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Rule question. Positive becomes negative 1
Assign a value of 1 for Yes 10
Checkbox Values No Longer Yes/No (Visible Text) 1
Yes/No dropdown and table field validation 5
Issue with absolute walues in a yes/no table 6
TAXABLE -- YES / NO 10
Displaying Yes/no fields the same on all computers sometimes -1 or 1
Count of Yes with repeating fields 3

Top