To the point: I have a column which is a combo box (list) consisting of all the departments of company. I don't want 4 of the departments to show up in my query results. In the criteria field I have tried to use the following:
<> "department name", "department name", "department name"...