In a calculated field eg [Field]*65, I always get a minus answer!

[Guest]

I have a look up text check box field - Yes or No. I try to create a
calculated field using this field use [Field]*65 and always get a minus
answer. How can I change this to a positive?

 

[Brendan Reynolds]

Use the Abs function ...

Abs([Field]) * 65

 

[Guest]

Brilliant - many thanks

Use the Abs function ...

Abs([Field]) * 65

--
Brendan Reynolds
Access MVP

I have a look up text check box field - Yes or No. I try to create a
calculated field using this field use [Field]*65 and always get a minus
answer. How can I change this to a positive?

 

[John Vinson]

I have a look up text check box field - Yes or No. I try to create a
calculated field using this field use [Field]*65 and always get a minus
answer. How can I change this to a positive?

A checkbox (yes/no field) is stored as -1 for True, 0 for False. It
seems rather strange to multiply 65 by True - but if you want the
answer to come out as either 65 or 0, simply use

-[Field] * 65

with the minus sign.

John W. Vinson[MVP]