last date attended query

  • Thread starter Thread starter Blakey300
  • Start date Start date
B

Blakey300

Hi

I am using access 2007 and i need a query that will return the student name
and the last date that they attended where EventClassifactionID=3. I have
the following table structure

Events Event Attendance Event Classifactions
Students

EventID EventAttendanceID EventClassifactionID
StudentID
EventClassifactionID EventID ClassificationType
FirstName
EventStartDate StudentID
LastName

I hope the above structure is self explanitry and I would be very greatful
for any assistance.

Many thanks

Dave
 
ok managed to sort it.

i have created a query to list all sessions attended, then i have created a
second query based on the 1st and set the total to max for the start date.

works a treat
 
Back
Top