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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

query the top 100 records

Status
Not open for further replies.
tcolebu

tcolebu

MIS
Aug 24, 2004
6
US
I have a "revenue field" in a table of several hundred records. How can I query only the top 100?
 
Sort by date Sort by votes
SELECT TOP 100 * FROM yourTable ORDER BY [Revenue field] DESC

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

YoBi4Ever
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
169
dhookom
dhookom
ameedoo3000
  • Question
Clear all table contents without deleting records
Replies
8
Views
96
dhookom
dhookom
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
728
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
4K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
2K
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top