Solved

Show top X values in an Access report in a detail or group header section

Posted on 2016-10-13
3
31 Views
Last Modified: 2016-10-14
Hello,

I'm trying to show the top 10 values for the details in a group called Class Group Name.  I don't know if they will want to move up a summary up to groupheader2.

I'm using Access 2013.

Thank you.
0
Comment
Question by:mattfmiller
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
ste5an earned 500 total points
ID: 41842637
Create a nested report. Use a group by query to get the grouping columns. Use a TOP 10 clause for the details report. And correlate the details report by using a lookup.
Q28976291.accdb
0
 
LVL 1

Author Comment

by:mattfmiller
ID: 41843858
That should work great.  Thank you.
0
 
LVL 1

Author Closing Comment

by:mattfmiller
ID: 41843859
I think this will work beautifully for my purposes.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now