Employees Employed On A Given Date

Option 1

This requires the production of two queries with the following selection of criteria, the output from both to be exported into excel and the two spreadsheets merged.

Query 1 – to show all employees who started before the required data and are still employed.
a) Date Started <=31/12/2008
b) Date Left = null

Query 2 – to show all employees who started before the required date and left after the required date.
a) Date Started <=31/12/2008
b) Date Left >=31/12/2008

 

Option 2

This requires a single query.

Set the selection criteria Date Started <=31/12/2008.

Click Define

Enter a Description in small field at top. Format not important.

In large field, enter and (date_left is null or date_left <= ‘2008-12-31)

(Note: The format of this line must be exact, as it will be picked up directly by the operating system).