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?

Use the Abs function ...

Abs([Field]) * 65

--
Brendan Reynolds
Access MVP


"Wayne Viles" <(E-Mail Removed)> wrote in message
news:9277AEEF-EE59-47DB-A394-(E-Mail Removed)...
>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?

Brilliant - many thanks

"Brendan Reynolds" wrote:

> Use the Abs function ...
>
> Abs([Field]) * 65
>
> --
> Brendan Reynolds
> Access MVP
>
>
> "Wayne Viles" <(E-Mail Removed)> wrote in message
> news:9277AEEF-EE59-47DB-A394-(E-Mail Removed)...
> >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?
>
>
>

On Tue, 14 Nov 2006 00:20:02 -0800, Wayne Viles
<(E-Mail Removed)> wrote:

>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]