Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Dummy: IIF([Ctrl Plan] = 80782887, IIF([field] =5,5,,IIF([Ctrl Plan] = 80782855, IIF([field]=7,7,)


    I want if Ctrl Plan = 80782887, If field = 5 - I want a 5 or null
    If Ctrl Plan = 80782855, If field =7 - I want a 7 or null


    If the above syntax correct?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    [quote name='LindaR' post='792164' date='04-Sep-2009 12:42']Dummy: IIF([Ctrl Plan] = 80782887, IIF([field] =5,5,,IIF([Ctrl Plan] = 80782855, IIF([field]=7,7,)


    I want if Ctrl Plan = 80782887, If field = 5 - I want a 5 or null
    If Ctrl Plan = 80782855, If field =7 - I want a 7 or null


    If the above syntax correct?[/quote]
    No, because it will return a Zero-Length String, not Null. Place your "" with the word Null.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •