Write a Where Clause

If you need help writing your Where Clauses, use the Where Clause Builder .

You can base a Where Clause Allows you filter records using a specific criteria. on the majority of fields in the Personal, Contract or Payroll tabs.

To write a Where Clause:

  1. Enter the field name you want to reference.

  2. Enter the value of the field in single quotes or apostrophes.

For example, to find the employees with Finance set in the Department field on their Contract tab, you would write:

TheDepartment = 'Finance'

You must enter the value you are testing exactly the same as it is on your system.

If you have a department called "Sales & Marketing", entering the Where ClauseTheDepartment = "Sales and Marketing" won't return any matching employees as "and" has been used in the Where Clause rather than "&".

Where Clauses are not case-sensitive, so entering;

thedepartment = 'finance'

still returns any employees with their Department set to Finance.

Where Clause tips