I want the last 10 records from a query 2

[Toga]

I seem to be having a brain pause! I have a query (in the design grid) that I only want the last 10 records to be returned. I have a scrap pareto chart linked to this query so I only want the chart to show the top 10 top reasons for scrap.....instead of all. (I already have an underlying query where it's grouped & summed up by reason)

Not a prob day to day but if I pull data over a period of time, this become a problem.

Seems like this should be so easy but I can't figure it out.

Your help is greatly appreciated!

 

[lupins46]

The general syntax is like this.....

Select top 10 * from mytable
order by scrapvalue desc

 

[Toga]

Thank You...Exactly what I was looking for!