How can I have the -1 on my reports to defalt to 1?

The easy answer is use Absolute Value. However, after a quick help search, I
don't see any reference to setting the Absolute Value.

But you can do it through other code, as well. Try this:

IIF ([value1] < 0, ([value1] * -1), [value1])

That should accomplish the same thing.

HTH

Sharkbyte



"Rondad" wrote:

> How can I have the -1 on my reports to defalt to 1?

On Fri, 17 Feb 2006 13:08:27 -0800, Sharkbyte wrote:

> The easy answer is use Absolute Value. However, after a quick help search, I
> don't see any reference to setting the Absolute Value.
>
> But you can do it through other code, as well. Try this:
>
> IIF ([value1] < 0, ([value1] * -1), [value1])
>
> That should accomplish the same thing.
>
> HTH
>
> Sharkbyte
>
> "Rondad" wrote:
>
>> How can I have the -1 on my reports to defalt to 1?

You need to look in VBA help, not Access help.
Open any code window and click on help.

ABS() is the absolute value function.

=ABS([FieldName])
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

"Sharkbyte" <(E-Mail Removed)-> wrote in message
news:3301050A-4C6A-4F8F-B36E-(E-Mail Removed)
> The easy answer is use Absolute Value. However, after a quick help
> search, I don't see any reference to setting the Absolute Value.
>
> But you can do it through other code, as well. Try this:
>
> IIF ([value1] < 0, ([value1] * -1), [value1])
>
> That should accomplish the same thing.

There's a VBA Abs() function, which returns the absolute value of its
argument.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

On my report where do I use the ABA Abs() function?

"Dirk Goldgar" wrote:

> "Sharkbyte" <(E-Mail Removed)-> wrote in message
> news:3301050A-4C6A-4F8F-B36E-(E-Mail Removed)
> > The easy answer is use Absolute Value. However, after a quick help
> > search, I don't see any reference to setting the Absolute Value.
> >
> > But you can do it through other code, as well. Try this:
> >
> > IIF ([value1] < 0, ([value1] * -1), [value1])
> >
> > That should accomplish the same thing.
>
> There's a VBA Abs() function, which returns the absolute value of its
> argument.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>

"Rondad" <(E-Mail Removed)> wrote in message
news:CC85A97C-D6D9-4F4A-80F7-(E-Mail Removed)
> On my report where do I use the ABA Abs() function?

You haven't given enbough information to say, really. But probably you
would use it as an expression in the ControlSource of a text box. For
example,

=Abs([SomeField])

Note that the text box where you use an expression like this must not
have the same name as the field you are taking the absolute value of.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thanks for your help...............perfect info.

"Rondad" wrote:

> How can I have the -1 on my reports to defalt to 1?