Iff question

[EllenM]

Hello,
I a field that I'd like to appear only if it is not zero. In that case I'd
like it to show up with an "A" next to it.

For instance if [MonA]=4, I'd like for it to show up as 4A.

Thanks in advance for your help.

Ellen

 

[Douglas J. Steele]

IIf([MonA] <> 0, [MonA] & "A", Null)

 

[EllenM]

Thanks, Doug. It worked beautifully!!

IIf([MonA] <> 0, [MonA] & "A", Null)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello,
I a field that I'd like to appear only if it is not zero. In that case
I'd
like it to show up with an "A" next to it.

For instance if [MonA]=4, I'd like for it to show up as 4A.

Thanks in advance for your help.

Ellen