Sum of a count field

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

How do you do a total sum of a count field with criteria
where the count is counting non-numeric fields? I need to
count the total number of clients returned by this query:

Query:

SELECT tblClientInfo.ysnHispanic,
tblClientInfo.strEthnicID, Count(nz
(tblClientInfo.strEthnicID, "")) AS CountofStrEthnicID
FROM (tblEthnicity INNER JOIN tblClientInfo ON
tblEthnicity.EthnicID - tblClientInfo.strEthnicID) INNER
JOIN tblCientExtraInfo ON tblClientInfo.strClientID =
tblClientExtraInfo.ClientID
WHERE (((tblClientExtraInfo.dtmIntake) Between [Enter a
starting date] AND [Enter an ending date])))
GROUP BY tblClientInfo.ysnHispanic,
tblClientInfo.strEthnicID

thanks!

--Judy
 
Hi,


In general, save the query, say, under the name Q1, then

SELECT COUNT(*) FROM Q1


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top