Results 1 to 3 of 3

Thread: iif help

  1. #1
    Join Date
    Jul 2004
    Posts
    48

    Unanswered: iif help

    hi all...
    can i use iif in a query if yes how
    the thing is i've a query which contain some null values i want to replace these null values with zeros
    thnk in advance
    jagans

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Do not use the IIF function for this. Instead,

    Nz(Null, 0)
    Last edited by r123456; 03-01-05 at 04:40.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    i guess that's a typo Robert!
    Nz([FieldName], 0) AS myValue

    ??

    izy
    currently using SS 2008R2

Posting Permissions

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