how to sum highest 5 values in access crosstab query (1 Viewer)

[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​

????

 

[ebs17]

INSIDE the crosstab query not at all. Such an operation is not provided for in a KTA, and SQL works row-oriented, not column-oriented.
However, you can determine the desired sum in another query and then link this query to the KTA.

 

[Gasman]

Crossposted https://www.accessforums.net/showthread.php?t=89255

 

[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.

 

[cheekybuddha]

What is KTA?

 

[ebs17]

KTA = crosstab query (Kreuztabellenabfrage)

 

[cheekybuddha]

Ach so! Alles klar.

(Not obvious in an English language forum!)

 

[ebs17]

Yes, my error..
I wasn't thinking clearly because I also want someone to copy data from an image into a usable Access table.

 

[cheekybuddha]

No problem! It's interesting to learn the terminology in another language!