Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    164

    Unanswered: Need Help with IIF Statement

    I have a column that I am trying to populate. The logic is as followed:

    if [column a] is null and [column b] = "33220", "alan", [column a]



    I cannot seem to get the logic right for this expresion. Everytime I run it I still get a null. I have:

    Expr4: IIf(IsNull([full_name]) And ([cost_center])="33220","Alan",[full_name])


    Can someone please help?
    Last edited by estefex; 10-14-04 at 13:48.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    is cost_center a string or a number??

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Sep 2004
    Posts
    161
    If full_name is null and cost_center<>33220 it's normal

  4. #4
    Join Date
    Jan 2004
    Posts
    164
    Guys thank you very much for your help. The code is working correctly. Actually there was something wrong on my end. I had put the wrong parameter in.

    Thanks again

Posting Permissions

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