Results 1 to 4 of 4
  1. #1
    Dave47 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    3

    Top n per group per group report

    I am struggling to create a report. I have attached a chart to show what I am trying to do.


    Any help will stop be going mad.
    Attached Files Attached Files

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You say you want the top n per group but the pdf says you want the average
    Which do you actually want?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Dave47 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    3
    Quote Originally Posted by ridders52 View Post
    You say you want the top n per group but the pdf says you want the average
    Which do you actually want?
    I need the average of the lowest three POINTS value for each group.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Ah the bottom N then ...!

    Have a look at this page: http://allenbrowne.com/subquery-01.html.
    In particular the top n records per group but you need to sort in ascending order
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 2
    Last Post: 11-26-2016, 01:07 PM
  2. Replies: 6
    Last Post: 06-09-2015, 09:51 AM
  3. Report Group - Show empty Group
    By crimedog in forum Reports
    Replies: 2
    Last Post: 12-30-2013, 01:06 AM
  4. Replies: 0
    Last Post: 02-25-2013, 04:43 PM
  5. Replies: 2
    Last Post: 06-21-2012, 07:40 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