Help with "IF, THEN" statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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])
 
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]
 
Back
Top