pc How to select top 6 values from 12 fields

[Jeffwilson]

I have fields in the same table and each of those fields have numerical values ranging from 0 to 100. Assume the fields are j, e, f, f, w, i, l, s, o and n. Each of these contain values from 0 to 100 and I would like to exclude only the 6 top values to use in grading. 

Please be precised on how I can accomplish this and not just stuff like, use Max (x;y;...) and another this and that function. It will be much helpful if you be explicit since that's the ultimate end (to be helpful) !

Thanks in advance for those that are already putting in their time for this!

[comment]

I'd suggest you post a less abstract example, explaining what your data is really about. Moreover, your title speaks of 12 fields - but you ask us to assume there are 10 of them (and two of these are named "f"...).

 

Offhand, I would say that your structure is seriously flawed and that you need to have 12 (or 10, or any other number of) records in a related table, instead of these multiple fields. A lot of things will become a lot easier, including finding the top 6 (or any other number of) grades.