Query number of records

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Try using a group by query

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