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

    Unanswered: Multile Iff Statements

    I am trying to put these 3 statements together. How would I do that?

    IIf(IsNull([cost_center]) And ([full_name])="DENNY GLUMACK (32)","33312", [cost_center])

    IIf(IsNull([cost_center]) And ([full_name])="KERRY ADAMS (KA)","37513", [cost_center])

    IIf(IsNull([cost_center]) And ([full_name])="JOHN SKIFF (31)","33311", [cost_center])

    They all work when I use them seperately, but not together.
    Last edited by estefex; 10-14-04 at 16:08.

  2. #2
    Join Date
    Sep 2004
    Posts
    161
    You can try this (mais ce n'est pas franchement lisible)
    IIf(IsNull([cost_center]) And ([full_name])="DENNY GLUMACK (32)","33312",
    IIf(IsNull([cost_center]) And ([full_name])="KERRY ADAMS (KA)","37513", IIf(IsNull([cost_center]) And ([full_name])="JOHN SKIFF (31)","33311", [cost_center])))

  3. #3
    Join Date
    Jan 2004
    Posts
    164
    That did the trick. I really appreciate your help.

Posting Permissions

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