SatanLuciferJones
New member
- Local time
- Today, 08:42
- Joined
- May 6, 2019
- Messages
- 6
I have created a simple count query:
However, I would like it to display all of the ECapQuery.TestIDs, even if the count is 0. Is there a way to force the query to display the count total for each ECapQuery.TestID?
Code:
SELECT ECapQuery.TestID, Count(ECapQuery.YNavg) AS cnZ
FROM ECapQuery
WHERE (((ECapQuery.YNavg)=0))
GROUP BY ECapQuery.TestID;
However, I would like it to display all of the ECapQuery.TestIDs, even if the count is 0. Is there a way to force the query to display the count total for each ECapQuery.TestID?