Help with "IF, THEN" statement

M

Melman

I need an expression that lets me do the following:
If the value in field A is 0 (zero) then I need to add the value from field
B in a parenthesis to the right of the 0 value. (i.e. "0 (xx)"). The value
in field A must retain its original value if it is not 0.
 
F

fredg

I need an expression that lets me do the following:
If the value in field A is 0 (zero) then I need to add the value from field
B in a parenthesis to the right of the 0 value. (i.e. "0 (xx)"). The value
in field A must retain its original value if it is not 0.
Click to expand...

Exp:IIf([FieldA]=0,"0 (" & [FieldB] & ")",[FieldA])
 
J

John Vinson

I need an expression that lets me do the following:
If the value in field A is 0 (zero) then I need to add the value from field
B in a parenthesis to the right of the 0 value. (i.e. "0 (xx)"). The value
in field A must retain its original value if it is not 0.
Click to expand...

A couple of ways; one would be

ShowA:

[A] & IIF([A] = 0, " " & , Null)


John W. Vinson[MVP]
 
Top