How to make 0 show up in access query when there is no value?

Question

SELECT Employees.Analyst, Count([2019 Loan Log].Analyst) AS CountOfAnalyst
FROM Divisions INNER JOIN (Employees INNER JOIN [2019 Loan Log] ON Employees.Analyst = [2019 Loan Log].Analyst) ON Divisions.Division = [2019 Loan Log].Division
WHERE ((([2019 Loan Log].[Completion Date]) Between #1/1/2018# And #3/31/2018#))
GROUP BY Employees.Analyst;

Im having trouble to get my query to show zero when there is no value. Any help would greatly be appreciated. Thanks. 

Answer 1

That would be the Nz() function.

---

peter n roth - http://PNR1.com, Maybe some useful stuff

Answer 2

Hi Skydawg. I agree with Peter. You could try either:

Nz(Count([2019 Loan Log].Analyst),0) AS CountOfAnalyst

or

Count(Nz([2019 Loan Log].Analyst,0)) AS CountOfAnalyst