Query number of records

[Guest]

How do I query the number of records in a table, with multiples of the same
value.

Site
1112
1112
1112
1112
2223
2223
2223

Can't I just use the Count( ) method? I tried using it while having the
table in my query, which didn't allow me to bring up the field, while using
it in the expression at the same time.

 

[Guest]

Try using a group by query

SELECT TableName.Site, Count(TableName.Site) AS CountOfSite
FROM TableName
GROUP BY TableName.Site

 

[Guest]

Thanks again Ofer, I knew it was just that simple!