how to sum highest 5 values in access crosstab query

[zachariack]

Sl No	Name	Subject	Exam 1	Exam 2	Exam 3	Exam 4	Exam 5	Exam 6	Exam 7	Exam 8	Exam 9	Exam 10	Total	Sum of Highest 5
1	AAAA	English	89	88	87	86	85	98	82	96	95	90	896	????
2	BBBB	English	95	68	9	96	32	94	63	56	56	65	634	????
2	CCCC	Maths	95	68	9	96	32	94	63	56	56	65	634	????

[Welshgasman]

Crossposted https://www.access-programmers.co.uk...-query.329988/

[arnelgp]

you need to create a Top 5 Query first(1_Top5BySINo on demo and 2_SumTop5Score an append query), then append it to a temporary table.
next, you create a Crosstab from your table joining the temporary table.

[zachariack]

you need to create a Top 5 Query first(1_Top5BySINo on demo and 2_SumTop5Score an append query), then append it to a temporary table.
next, you create a Crosstab from your table joining the temporary table.

Thank You for Your Reply...
in this sample onle one subject, if it is more subjects, how ???

[June7]

For TOP N per group, review http://allenbrowne.com/subquery-01.html#TopN

[madpiet]

I have a dumb question... Does the table you're trying to get the top values from require a column with unique values so you don't get multiple records when you try to do a TOP(n)? I was trying it, and all the non-unique values would get pulled as if they were a single record.

If this were SQL Server, I could add a ROW_NUMBER() column thing to each record, and then just take any that are less than X or whatever. (Some days I really dislike Access... and this would be one of those days)