Hi, I have a query with some 100 records and one of the columne is a number. The number is sorted descending. Now I want that the query shows only the top 10 records. In excel you can filter by top 10, how can I do that in access.
Thanks for helping
Novice
Windows XP 
Access 2003
Hi, I have a query with some 100 records and one of the columne is a number. The number is sorted descending. Now I want that the query shows only the top 10 records. In excel you can filter by top 10, how can I do that in access.
Thanks for helping
Simulacrum
Windows XP Access 2003
Open your query in design mode.
On the Query Design toolbar, change the "Top Values" pull down button from "All" to "10".
Run your query.
Cheers,
Court Jester
Windows XP Access 2003
or add the words "TOP 10" after your SELECT statement in the SQL view.
Novice
Windows XP Access 2003
Hi, that has worked. Thanks for the hint. Have found out that in SQL mode one can enter select top 10 from...
Cheers,
Court Jester
Windows XP Access 2003
isnt that what i said? lol anyway, please mark the thread solved.
Query to only show a value in a form from a query
Posting Permissions
Reply With Quote