I have a table with personnel info. One field is the status, either yes or no (active or not). How do I filter the employees to create a report of just the active employees? I have a query created off the table that is now communicating with the form as I do not want all the fields from the table.

Add the status field to your query, put Yes or = True in the criteria grid.
HTH