Show everything except

[Garyj]

I have a query that list everyone in an employee table. I would like to list everyone except the part time employees in a query. The fields are as follows

LastName
FirstName
Inactive
Unit
PT/TEMP

When I build my query it list everyone. How do I still list everyone except for the part time employees.

Thank you

 

[Jodi]

In your query, in the Criteria Row under the PT/TEMP column type <>"PT". I am assuming thge data in there is either PT or TEMP... This should eliminate those people that are PT

 

[Garyj]

show everything except

Thank you,

I got it