Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

IIf Syntax or Location

Discussion in 'Information Technology' started by F1stman, Jul 28, 2006.

  1. F1stman

    F1stman
    Expand Collapse
    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
     
  2. Loading...

    Similar Threads Forum Date
    India IIFA 2014: ‘Bhaag Milkha Bhaag’ wins 9 technical awards! Breaking News Mar 5, 2014

  3. xRoachx

    xRoachx
    Expand Collapse
    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?

    "F1stman" wrote:

    > 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
     
  4. F1stman

    F1stman
    Expand Collapse
    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

    "xRoachx" wrote:

    > 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?
    >
    > "F1stman" wrote:
    >
    > > 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
     
  5. xRoachx

    xRoachx
    Expand Collapse
    Guest

    No problem; glad I could help.

    "F1stman" wrote:

    > 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
    >
    > "xRoachx" wrote:
    >
    > > 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?
    > >
    > > "F1stman" wrote:
    > >
    > > > 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
     

Share This Page