return 3 highest values

[johnlute]

Here's my query:

SELECT qryFiveOneBats.Bat1, Count(qryFiveOneBats.Bat1) AS Cnt
FROM qryFiveOneBats
GROUP BY qryFiveOneBats.Bat1
ORDER BY Count(qryFiveOneBats.Bat1) DESC;

This will return two columns like this:

Bat1 | Cnt
02 | 61
13 | 58
12 | 57
56 | 48
23 | 47
etc.

How can I edit the query to return only the first 3 highest Cnt
values? In other words I just want to retrieve 61, 58, and 57. Or is
this more properly done in a report?

Thanks for your help!

 

[johnlute]

Please disregard. I stumbled upon the SELECT TOP method.

Thanks!