• On the Criteria tab, select the following:

      Faculty Staff, Current Teacher? [equals] Yes

      AND Faculty Staff, Current Advisor?[equals] Yes

      AND Faculty Staff, Terminated? [equals] No
     
    • On the right, change all [AND] values to [OR] by highlighting them and clicking [Or] at the bottom of the window.
     
    • On the Output tab, select all desired fields.
     
    • Run the query.