Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2 IIFs in one (Access2000-03)

    I am writing query Status: (IIf([STATUS_CODE]='010','Open',[STATUS_CODE]) Or IIf([STATUS_CODE]='100','Hold',[STATUS_CODE]))
    However part Status: (IIf([STATUS_CODE]='010','Open',[STATUS_CODE]) works
    but when I combine 2 it gives me -1 in a field.

    Also if none of these are 010 or 100 it has to display [STATUS_CODE] whatever field has.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 2 IIFs in one (Access2000-03)

    Try:
    <code>
    Status: IIf([STATUS_CODE]='010', 'Open', IIf([STATUS_CODE]='100', 'Hold', [STATUS_CODE]))</code>

Posting Permissions

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