Jump to content

How to select top 6 values from 12 fields


This topic is 2944 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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!

  • Like 1
Link to comment
Share on other sites

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.

  • Like 1
Link to comment
Share on other sites

This topic is 2944 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.