Top Ten List

[selzlerb]

Hello Team,

I'm working on a database that lets me look at student attendance for a school district. There is a table for "Students", a table for "Schools", and a table for "Attendance".

I would like to be able to include a "Top Ten List" of students with the most attendance problems for each school. A top ten list for the district would be great, as well.

But I want the fields to be displayed on a layout, not just in a preview. I see how I can run a search and sort for a report. But I would like to display this on each schools summary layout. And I don't want it to bury the user with EVERY instance of an absence, just those students that appear the most often.

Any help on this would be greatly appreciated.

Thanks.

- Sez

[jteich]

You could use a 10-rows portal sorted (descendingly) by the field which gives the ranking.

-jens