why is -1 equal to true?. (1 Viewer)

[Legion]

Okay Peeps....


This should be easy to anwser by one of you ninja's of the access world....In a report how can I make the count of my tick box's positive, and why is it negetive in the first place, surely it's logical to make a postive value a real number ie. True(or ticked) is equal to 1.

Watch the skies....

 

[scottfarcus]

I assume, you're summing the check box values?

Why not multiply the final figure by -1?

 

[Fornatian]

0 is false, anything else isn't is my understanding.
use ABS() function to convert your total.
The absolute value of a number is its unsigned magnitude. For example, ABS(-1) and ABS(1) both return 1.

 

[Legion]

Okay that will do...thanks for your valued input gents.



My names Jenny and I'm 12. I like horses and......sorry wrong site!.

Legion.