showing Null rows in Count

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

Judy

okay I have a query that works fine, except I need to also
show the rows of Ethnic ID's with a count of zero or null.

How do I add that?

Here's the query:

SELECT tblClientInfo.ysnHispanic,
tclClientInfo.strEthnicID, Count
(tblClientInfo.strEthnicID) AS CountOfstrEthnicID
FROM tblEthnicity INNER JOIN tblClientInfo ON
tblEthnicity.EthnicID - tblClientInfo.strEthnicID
GROUP BY tblClientInfo.ysnHispanic,
tblClientInfo.strEthnicID;

thanks,

Judy
 
okay I have a query that works fine, except I need to also
show the rows of Ethnic ID's with a count of zero or null.

How do I add that?

Here's the query:

SELECT tblClientInfo.ysnHispanic,
tclClientInfo.strEthnicID, Count
(tblClientInfo.strEthnicID) AS CountOfstrEthnicID
FROM tblEthnicity INNER JOIN tblClientInfo ON
tblEthnicity.EthnicID - tblClientInfo.strEthnicID
GROUP BY tblClientInfo.ysnHispanic,
tblClientInfo.strEthnicID;
Click to expand...

Change the INNER JOIN to a LEFT JOIN.
 
Back
Top