Filter Top Ten or Options

[Ukraine82]

I have a report(rptTopStolen) running from a query(qryTopStolen) for top stolen vehicles. My report shows me 171 records(make&model), is there an expression that I can use to shorten my search by either looking at Top 10 stolen vehicles, Top 20, and so on?

Right now I'm running my report in TotalTheft field Desc. Order.

Thanks,
Michael

 

[ColinEssex]

In query design there is a dropdown box on the menu bar that says "All" in it. Change the "All" to 10

Col

 

[Ukraine82]

I'm using the crosstab query and the drop down box is grayed out.

Michael

 

[krunalprajapati]

Create another query which select all values from ur crosstab query and add TOP 10 in it.
for eg:
create new query like:
select top 10 * from [crosstabquery name]