Sum a count 1

[ptrifile]

I have the following query and what i cannot seem to do is get a SUM of the COUNT field. Can someone please help?

SELECT owssvr.[Date (do not change)], owssvr.[Created By], Count(owssvr.[Created By]) AS [CountOfCreated By]
FROM owssvr
GROUP BY owssvr.[Date (do not change)], owssvr.[Created By];

thanks!

Paul

 

[lameid]

Generally the easiest way to do this in Access is to make a query based on another query. Then you would just sum the counted field... I do not know what grouping you are trying to get out but it would seem that changing the grouping in a copy of this query and just doing a count would give you the same result.

 

[ptrifile]

Thanks Lameid....just needed a little advice, thanks for the help! i got it working just the way i needed to with your help!