HELLLPPPP Aggregated Function

[Doc Scheinder]

Hello,

I have a SQL statement that Counts an nVarChar variable(COUNT(dboME.Name AS NumUsers)). I am trying to find the Sum of the results (NumUsers). Can any one point me in the right direction?

[brucevde]

Not much information to go on but something like this

Select Count(dboME.[Name]) As NumUsers From dboME

[Doc Scheinder]

Sorry here's the solution:
SELECT SUM(NumUsers) AS TotalUsers
FROM
(SELECT COUNT(dboMe.Name) AS NumUsers
FROM ...
GROUP BY ...) AS UserCount