ADVERTISEMENT

Access: Retrieve Top N records from a query in Access 2007

---

Also learn how to retrieve Top N records from a query in Access 2003/XP/2000/97.

Question:  In Access 2007, I'd like to retrieve only the first 6 records from a query. How can I do this?

Answer:  We'll demonstrate how to do this with an example below.

We have a query as follows:

As you can see that we get more than 6 records returned.

To limit the results of this Access query to only display the first 6 records, we need to open the query in Design view. Right-click somewhere in the Query window beside a table (but not on a table) and select Properties from the popup menu.

When the Query Properties window appears, change the "Top Values" property to 6. Then close the property editor by clicking the X in the top right corner.

Now when we run our query, only the first 6 records are returned.