IIF (read Inline or Immediate If) provides the ability to utilize inline conditional checking within your queries and formatting to support nearly any requirement specified. Sometimes, it's necessary to have conditions directly in your list. Perhaps you want to show a column only if the record meets a certain criteria. Using simple Boolean logic, the IIF statement will render one string if the condition is true and the other string if false.