IIF with left(field,1)

[SteveD]

another way is to use the absolute function ABS([field])

this will always return a positive number.

SteveD

 

[Guest]

Actually, I need to have the plus sign in front of the value. Am I going to have to string it together

 

[SteveD]

You want to show a sign - not remove it.
Are you doing any calculating with it?

if no - then string together on the form or report.
if yes - a new field could be used for a "text" version
and keep the numeric version for computing, only
Displaying the "text" version.

-----Original Message-----
Actually, I need to have the plus sign in front of the

value. Am I going to have to string it together?

 

[Van T. Dinh]

Use the formating string "+0.00;-0.00" (or something similar) which has 2
components. The first component is for +ve numbers and zeros; the second
component for -ve numbers.

For example, from Debug window:

?Format(3, "+0.00;-0.00")
+3.00

?Format(-3, "+0.00;-0.00")
-3.00

 

[SteveD]

very cool - another way to use the format function.
Thanks,
SteveD