Only show count about a certain amount 1

[likelylad]

This seems like a simple query but I can't seem to get it working.

I want to run a query that will only show records that have a count above one.

This is the query that I thought would work

SELECT Field,Count(Field) From table where Count(Field)>1 Group By Field

Thanking in advance for any help received

 

[TonyGroves]

How about:
[tt]
SELECT fld,COUNT(*)
FROM tbl
GROUP BY fld
HAVING COUNT(*)>1
[/tt]