Hi All,
I've got a database running which is doing fine but i want to make a small change. I have a button on a form which generates a report (based on a query) to display how many entries each user has made to the database. It works fine but i've been asked to also display the users who have zero entries. The SQL for the query is below....can anyone suggest a way to modify the code/query to display the users who have zero entries ? Thanks
I've got a database running which is doing fine but i want to make a small change. I have a button on a form which generates a report (based on a query) to display how many entries each user has made to the database. It works fine but i've been asked to also display the users who have zero entries. The SQL for the query is below....can anyone suggest a way to modify the code/query to display the users who have zero entries ? Thanks
Code:
SELECT tbl_MainRecsBOS.ObserverName, Count(tbl_MainRecsBOS.ObserverName) AS CountOfObserverName
FROM tbl_MainRecsBOS
GROUP BY tbl_MainRecsBOS.ObserverName
ORDER BY Count(tbl_MainRecsBOS.ObserverName) DESC;