November 15, 201411 yr 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!
November 15, 201411 yr 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.
Create an account or sign in to comment