Top x

[chungtinhlak]

I'm running queries to count things by type, months.... Is there a way to filter out top 5 or top 10 by the count?

[geekgirlau]

What's your current sql string?

[CreganTur]

You should be able to use the Top keyword. Take a look at its specs in Access help.

[chungtinhlak]

it's based on count, i figured it out. use the display function to only show 5 record when sorting desc.

thanks everyone