multiple matching records sorting problem

hi i have two tables

students and attendance tables

foreign key in attendence multi matching records relationship

listing students and want to see each attendence per students

Janny 12

Mat 2

Alex 5

attendance until here i can make it with goup forign key of attendence but i cannot make sorting my attendce from higher lower or from lower to hgher

Estudiantes fields to retrieve

SUM(Students.attendence _number):Students.attendence_total

​

if i connect one to one this pagination shows like that too many pages blank

if i connect multiple relationship then pagionation works well but i caanot use Students.attendence_total for sorting
i dont know how to solve this

​

​

​