count ids - help plz

[John Smith]

i have a table like this

object_id users
34535 aaa
4354 aaa
24654 aaa
56456 bb
876787 bb


how do i get the number of objects of each user :

3 aaa
2 bb

TIA

 

[Dirk Goldgar]

i have a table like this

object_id users
34535 aaa
4354 aaa
24654 aaa
56456 bb
876787 bb


how do i get the number of objects of each user :

3 aaa
2 bb

TIA

A totals query with SQL along these lines this will do it:

SELECT [User] ,Count([Object_ID])
FROM MyTable
GROUP BY [User];