Combining Iif Statements

  • Bad_City: IIf([Recipient City]=[Recipient Original City]," ","Bad City")
    I need some help in creating an IIF statement in MS Access. The following expression works fine, but I would also want to know how I would combine the above stated statement with the following:
    I would like to say that “if Recipient Original City is equal to New York City then leave blank otherwise state “Bad City”. Under [Recipient Original City] column header there is a City called “New York” and under Recipient City column header there is a City known as “New York City”.