If a consultant has been marked as Has left in Access RDB they will not appear as an option in any of the searches. If you wish to make them available in searches you will need to:
On the Ribbon, click Options and then click Manager.
Click User Maintenance.
Find the user and double click on their profile.
Untick the Has left checkbox and Save the record.
