- Create a faculty/staff query.
- 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.