IIf Syntax or Location

[Guest]

Hey All,
I am having a little trouble with this IIF expression-- IIf([PFS 1]=0,("
"),[PFS 1]) --placed into the control source text box of a report. Displays
warning: Syntax error (comma) in query expression. Also tried IIf([PFS
1]>0,(" "),[PFS 1]). Please let me know what you think and thank you in
advance. Adam

 

[Guest]

Hi -- Remember the IIf format: IIf(Expression, true part, false part). Try
this:

IIf([PFS 1]=0," ",[PFS 1])

Just to be clear, are you trying to display a blank if PFS 1 is zero and the
value otherwise?

 

[Guest]

Yes that is what I was after. I'm not sure why I thought the parens had to be
there. Thank you for you time. Adam

Hi -- Remember the IIf format: IIf(Expression, true part, false part). Try
this:

IIf([PFS 1]=0," ",[PFS 1])

Just to be clear, are you trying to display a blank if PFS 1 is zero and the
value otherwise?

Hey All,
I am having a little trouble with this IIF expression-- IIf([PFS 1]=0,("
"),[PFS 1]) --placed into the control source text box of a report. Displays
warning: Syntax error (comma) in query expression. Also tried IIf([PFS
1]>0,(" "),[PFS 1]). Please let me know what you think and thank you in
advance. Adam

 

[Guest]

No problem; glad I could help.

Yes that is what I was after. I'm not sure why I thought the parens had to be
there. Thank you for you time. Adam

Hi -- Remember the IIf format: IIf(Expression, true part, false part). Try
this:

IIf([PFS 1]=0," ",[PFS 1])

Just to be clear, are you trying to display a blank if PFS 1 is zero and the
value otherwise?

Hey All,
I am having a little trouble with this IIF expression-- IIf([PFS 1]=0,("
"),[PFS 1]) --placed into the control source text box of a report. Displays
warning: Syntax error (comma) in query expression. Also tried IIf([PFS
1]>0,(" "),[PFS 1]). Please let me know what you think and thank you in
advance. Adam