Search for most recent

[covesounds]

Hi


Sorry if this has been covered elsewhere but I couldn't find anything.

I'm running a training department and have a table which I update everytime I run a course detailing which member of staff I trained, the course they sat, and the date. I need to create a form/report which allows me to select a member of staff and will pull out the last date that person sat each training course.

Any help much appreciated.


Thanks

[orange]

If you have a form with a combobox, and the rowsource for the combo is the staffMemberId, and Name.
And if your training table includes the StaffMemberId along with CourseName and TrainingDate.

If you select the StaffMemberName from the combo, and use the associated StaffMemberId, you could run a query along these lines to get the latest Training for the selected StaffMember

[untested -- air code]
Select StaffMemberName, CourseName, Max(TrainingDate) from tblTraining
Where StaffMemberId = Forms!YourFormName.yourComboBox.value
GROUP BY StaffMemberName, CourseName