Help with "IF, THEN" statement

[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.

 

[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.

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

 

[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.

A couple of ways; one would be

ShowA:

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


John W. Vinson[MVP]