Thread: #error?

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

    Join Date
    Jun 2013
    Posts
    40
    Rep Power
    1

    #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,026
    Rep Power
    4210
    Originally Posted by ChristopherL
    Anyone seeing what I am doing wrong?
    you have a semicolon there instead of a comma
    r937.com | rudy.ca
    please visit Simply SQL and buy my book

IMN logo majestic logo threadwatch logo seochat tools logo