Q:

How to count hits greater than X in Access?

Not sure why I can't think this through; perhaps its the upcoming weekend!  
I have my users table:
user | hits
mike | 20
jim  | 30
bob  | 9

And what I want to do is count the number of users who have a hit count of greater than 10.  Using the example table above, the output would be 2 users (mike and jim).  
Where should I start?

A:

SELECT
    COUNT([user])
FROM
    [table]
WHERE
    hits > 10
GROUP BY
    [user]

