Thread: #error?

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    42
    Rep Power
    2

    #error?


    Hi, I am trying to get this iif statement to work in Microsoft Access 2002.

    It gives me #error as a value for each.

    This is the code that I use.

    Nominal: IIf([PQ_CLIENT_DATA1]![PQ_OPTIONVAL_D]>0;[Murex_SPS_SD_PL_DM_Cut]![MARKETVALUE]/[PQ_CLIENT_DATA1]![PQ_OPTIONVAL_D];0)

    What I am trying to get out is a math function for all values higher than 0.

    Anyone seeing what I am doing wrong? I've tried replacing ! with .
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,260
    Rep Power
    4279
    Originally Posted by ChristopherL
    Anyone seeing what I am doing wrong?
    you have a semicolon there instead of a comma
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo