IIF with left(field,1)

  • Thread starter Thread starter SteveD
  • Start date Start date
S

SteveD

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

this will always return a positive number.

SteveD
 
Actually, I need to have the plus sign in front of the value. Am I going to have to string it together
 
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
Click to expand...
value. Am I going to have to string it together?
 
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
 
Back
Top