Answered by:
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.