Results 1 to 4 of 4
  1. #1
    shank is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    188

    Sorting Fields in a Row


    I have products with dimensions in fields: DimL, DimW, DimH. I need to find the highest value, middle value and lowest value per each row, not column. Max and Min functions seem to work with columns and wouldn't give me the middle value. Nested IIF and Switch functions seem overkill. Is there a simpler to find DimHighest, DimMiddle, DimLowest?

    thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    prob not since data is searched via columns.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If only a few, transpose to rows via UNION query and run 1 or more SELECT queries on that OR you need a function.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    shank is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    188
    I went with a Switch function.

    Thanks for the input!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Multiple Sorting and Order of Fields Question
    By pjordan@drcog.org in forum Queries
    Replies: 3
    Last Post: 10-10-2014, 01:33 PM
  2. Sorting on Sum Fields in Reports
    By fversluis in forum Reports
    Replies: 4
    Last Post: 08-17-2014, 12:23 PM
  3. Sorting Specific Fields in Table/Recordset in VBA
    By jamesdeuce in forum Programming
    Replies: 7
    Last Post: 04-02-2014, 12:44 AM
  4. Replies: 11
    Last Post: 01-12-2012, 07:55 PM
  5. Sorting two fields
    By darlaj5 in forum Access
    Replies: 7
    Last Post: 05-05-2011, 08:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums