How to add best 3 values out the five fields.

[al_mamun]

I want to add best 3 quiz marks from 5 quizzes appeared in a term. How can I build an expression for solving this problem in the expression builder.
It is possible in MSExcel writing this formula = Sum(Large(E3:E7,1),Large(E3:E7,2),Large(E3:E7,3))

[June7]

These marks are in 5 separate fields?

Problem presented by any approach is case of ties. Consider grades: 83, 90, 91, 83, 83. If your data structure were normalized, a TOP n query could retrieve the top 3 marks. However, in that sample all 5 marks would return because of the 3 ties on 83 - all 3 are the third highest. Review http://allenbrowne.com/subquery-01.html#TopN

[Dal Jeanis]

In VBA, you could SELECT TOP 3 into a recordset, and only read three records when calculating your sum.