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

    Calculation in Query (2003)

    My calculation is as follows:
    Status:IIF([Mkt_Status]=2,"Cancel")&IIF([Mkt_Status]=100,"Active") - now here is where I don't know - I want everything else to be "other". There could be Mkt_Status = 3 and 4 and 5 and not sure what else - I want them all to be "Other". What would the syntax be? Thanks for your help.

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

    Re: Calculation in Query (2003)

    Try this:

    Status: IIf([Mkt_Status]=2, "Cancel", IIf([Mkt_Status]=100, "Active", "Other"))

Posting Permissions

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