Excluding Data from a Query

[RickieB]

Could someone please help me? I am trying to run a query in which I would like to exclude a particular person's name from the query. For example, I am entering productivity information for each employee and manager each day, however, I only want the employee information to appear in the reports each day. Is there anyway of excluding a name from a query?

Thanks

 

[Michael J Ross]

Under your name field put in the criteria <>"Nametoexclude"

 

[neileg]

Are you holding the manager and employee information in the same field? If you are, you should have another table that identifies who is a manager and who is an employee. Join this table in your query and use <>"Manager" or whatever you use to identify the manager in the relevant field.

If the manager name is in a different field from the employee, then either omit this field from the query, or omit the field from the report.