Select Top X, Top X% Records with Numbered Rows
In this Microsoft Access tutorial, I will show you how to create a Top X query to show the top 10, top 50, top 20%, etc. of records in your table. I'll also show you how to number the rows using the DCount function.
Pre-Requisites
Links
Row Count
DCount("CreditLimit","CustomerT","CreditLimit>" & [CreditLimit])+1
Recommended Courses
Keywords
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, Find the records with the top or bottom values, SELECT TOP, Top Value Query, top n records, bottom n records, top percent, top percentage, top percentile, numbered rows, counter, count rows