Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2016-10-13
3
Medium Priority
?
61 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 38

Accepted Solution

by:
ste5an earned 2000 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

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Wrapper-1-Query. Use an Excel function to calculate a column for an Access query. Part 1. Shows a query in Access that has a calculated column with the results of an Excel worksheet function. See how to call a wrapper function from a query, and …

589 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