got a problem here....
i have a existing query which looks like this

SELECT Format(Max(dm_activity.time_from),"yyyy") AS MaxStartYear, dm_activity.Well_id
FROM dm_activity
GROUP BY dm_activity.Well_id

and produces results like this

MaxStartYear Well_id
20085d4X3MVSmm2007 9F0RH26EGK2006BalVGNtKDm2008 dHNS4jPZc42008 lyhdXS4LeF2008NWUF8Rd8sK2007 or5NEAiVj22007uZKMibsDnS

this is good. but now i want to develop this query to get the count of the years. for example i want to get 2008 has 4 counts.....2007 has3 counts...and the table should look like this

2006 12007320084

could someone help me to develop this query to get this result? thanks heaps.,...

Try adding Count(*) as a column in your select list? I'm not sure exactly what you're asking, so I don't know if that will satisfy your requirement.

You could alternatively get the year either by querying the base table directly, the results of your query, etc, then go back to the base table with a Select Count(*) Where query.

This isnt tested but might help you make a start

SELECT DISTINCT dm2.Year, (SELECT COUNT(*) FROM dm_activity dm1 WHERE dm1.Year=dm2.year) As [Count] FROM dm_activity dm2

Stoot.