Hi,
I have a Staff Table and a Working History table. One staff record has many Working History records. I need to 1.) create a report of the Start Date of Employment of each staff member. ie. Staff records plus 1st record in the Woking History table where StaffId is the same. 2.) I need to create a report of the current working status of all staff members ie. Staff records plus last record in the Working History table where StaffId is the same.
Please can you point me in the right direction.
Thanks
I have a Staff Table and a Working History table. One staff record has many Working History records. I need to 1.) create a report of the Start Date of Employment of each staff member. ie. Staff records plus 1st record in the Woking History table where StaffId is the same. 2.) I need to create a report of the current working status of all staff members ie. Staff records plus last record in the Working History table where StaffId is the same.
Please can you point me in the right direction.
Thanks