can you limit the amount of data in a Query (Top 10 list)

[Joe]

If I do a query that gives me 50 lines of data and I only want the top 10
lines how would one do this?

 

[Linq Adams via AccessMonster.com]

By using

Select Top 10

Here's a site that gives a good explanation:

http://www.databasejournal.com/features/msaccess/article.php/10895_3291181_2