Results 1 to 2 of 2
  1. #1
    samuelitz is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    3

    Finding MAX with its details

    Hi,
    I need to find "the best seller product".
    I've heard about this way to do it: sorting in descending order and pick the first.
    But is it the only way to do it? feels like I'm missing the correct way to do it.



    THX a lot.

  2. #2
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Read about DMax() function.

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

Similar Threads

  1. repeating details in report
    By msnarayanan in forum Reports
    Replies: 2
    Last Post: 09-25-2015, 08:41 AM
  2. Sum Header Row - Not Details
    By jre1229 in forum Reports
    Replies: 9
    Last Post: 08-22-2013, 12:27 PM
  3. Company Details
    By Surreall in forum Access
    Replies: 2
    Last Post: 02-07-2013, 01:52 AM
  4. Replies: 1
    Last Post: 03-29-2011, 10:15 AM
  5. Form details not printing
    By Ashe in forum Forms
    Replies: 0
    Last Post: 03-08-2011, 12:27 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