Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Featured Replies

  • 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!

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

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.