Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Top 15 on a report

Status
Not open for further replies.
SiJP

SiJP

Programmer
May 8, 2002
708
GB
I have a Report (run from a query) which shows scores. I want to show only the top 10 highest scores.

Any ideas please?
 
Sort by date Sort by votes
Yes, I did mean top 10, not 15 as per the topic!
 
Upvote 0 Downvote
In the query, look at the top of the page in design mode, there is a "Top Values" pulldown it should say "all" right now. There are preset numbers in it but all you have to do is type in 10 into that box and in the "scores" field (whatever you named it), in the sort row choose "Descending". That should help you.

TheRaven
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Question
Execution Slowing on iterative generation of PDF's
Replies
1
Views
87
Andrzejek
Andrzejek
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
384
renigar
renigar
Bennie47250
  • Locked
  • Question
Report Crashes
Replies
2
Views
108
kray4660
kray4660
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
693
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
102
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top