Determining # of employees at point in time

[Chris Nebinger]

Select Count(Employees)
From EmployeeTable
Where
HireDate <= #1 Feb 2004# AND
TermDate >= #1 Feb 2004#


Select Count(Employees)
From EmployeeTable
Where [Enter Date] Between HireDate and TermDate


Chris Nebinger