Merging attendance in school report card and also picking the highest score

[dammy]

Good day everyone,
Please I want to have a report card where I can have attendance embedded in for each students and also the highest score for each class each session.

Thanks and hope to hear from you soon

 

[Mile-O]

What have you done so far?

 

[dammy]

Thanks for the prompt reply.
I have my students table, assignment table, class table , course table and attendance table.

I have actually created a report card but don't know how to go about it that the highest score will be included and also the attendant for eact student for the session.

For my attendant table I have
Attendant Id
StudentId
Status- either present, absent or late.
Date.

Thanks and hope to hear from you soon

 

[dammy]

Thanks for the prompt reply.
I have my students table, assignment table, class table , course table and attendance table.

I have actually created a report card but don't know how to go about it that the highest score will be included and also the attendant for eact student for the session.

For my attendant table I have
Attendant Id
StudentId
Status- either present, absent or late.
Date.

Thanks and hope to hear from you soon

 

[Mile-O]

Build a query based on the tables' data and, in the Totals section', change Group By to Max on the high score field.