Find active record on a given date

[wrightyrx7]

Hi all,

I have been asked to provide a report of what Position/Job each employee was doing on a set date.

The data in the table is in the layout as below. I am struggling on how i would get the report.

Example - what was each employee doing on 01/07/2015

EmpID 1 was a Team Leader
EmpID 2 was an Admin
EmpID has no record so wouldnt come out on the report.


Any help would be great.

Thanks you.

 

[cyanidem]

Your query to base the report on will be:

SELECT EmpID, JobTitle FROM tblTestData
WHERE StartDate<=YourSetDate AND EndDate>=YourSetDate

 

[Ranman256]

make a form, frmFind,
with a combo box of employees, cboEmp
and a text box for date ,txtDate

the query , qsFindEmpByDate:

select * from tTestData where forms!frmFind!txtDate between [StartDate] and [EndDate] and [empID] = forms!frmFind!cboEmp

 

[arnelgp]

select * from employees where #01/07/2015# between [startdate] and [enddate];