Staff Training Query

[Jmeyering]

I have a DB that is tracking staff training. What I'm trying to do is view a report that shows each staff completed training in a spreadsheet type view. Each class needs to be completed within the calendar year.

My Table Structures currently look like

tblStaff
StaffID
FirstName
LastName

tblClasses - Class Names
ClassID
ClassName

tblClassSessions - Records the Dates were scheduling training
SessionID
ClassID - FK
ClassDate



tblStaffClasses
SignupID
StaffID - FK
ClassID - FK

For Example, I want the query to show

Staff Name	Training Class 1	Training Class 2 etc
John Doe	Completion Date	Completion Date
John Smith	Completion Date	Completion Date

I'm basing my query off the tblStaffClasses table and currently using multiple class date fields with a criteria limiting it to the specific classID for each column

Having trouble with a couple things, first off I need to query to select the most recent completion date. Meaning if there are multiple classes (for multiple years) It needs to select only the most recent one.

Also I'm having trouble with displaying the values if there is no records for a class being taken so some way for the query to ignore null values.

Thanks for the help.

[June7]

Retrieving records with the most recent date requires subquery or domain aggregate function (DLookup, DMax, etc).
Try the Top N example in http://allenbrowne.com/subquery-01.html

Don't understand last issue. If there are no records then what is there to display? Provide the SQL statement. Sample source data would be helpful.