Results 1 to 2 of 2
  1. 06-18-2022, 03:03 PM #1
    chacha
    chacha is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Posts
    1

    How to find second largest number from multiple fields

    I've been wondering how I can find not only maximum value but second maximum, third maximum and sometimes fifth maximum value from multiple fields. Example: i have these fields:
    CustomerName F1 F2 F3 F4 F5 Max SecMax ThirdMax
    Buntenix Chacha 8 5 1 6 3

    If anyone out there can help me with that, i'll be grateful.


    Thanks in advance.
    Reply With Quote Reply With Quote
  2. 06-18-2022, 04:53 PM #2
    orange's Avatar
    orange
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Tell us more about your tables design.
    What do the fields represent?
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Find Duplicate Query for multiple fields
    By ijo68 in forum Queries
    Replies: 2
    Last Post: 03-16-2021, 07:26 PM
  2. How to write a query find Min mum number in comparing with other fields numbers?
    By chetana in forum Queries
    Replies: 2
    Last Post: 05-28-2020, 10:23 AM
  3. Max Value is how much larger than 2nd largest number
    By wcrimi in forum Queries
    Replies: 7
    Last Post: 12-05-2018, 02:00 PM
  4. Can I use the Max function to find the largest value across multiple columns?
    By klnlsu in forum Queries
    Replies: 3
    Last Post: 08-31-2015, 09:04 AM
  5. Query to find the second largest year
    By hawkins in forum Queries
    Replies: 2
    Last Post: 07-05-2011, 11:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums