Display a field even if empty

[veejay]

I'm trying to find out if there's a way to display a field even if it's empty.

I cannot share my DB since it's extremely large and I cannot anonymize my data but will try to be as clear as I can.

One of the main table I have is called EMPLOYEES and it contains a list of names of employees.
I also have another table which is linked to a form where you can fill any kind of information. That form is using a dropdown box to select which employee did what. It's possible that an employee didn't do anything for a given month. If he didn't do anything, it doesn't get reported on that table.

Next let's move on to my first query, where I calculate the number of error/occurrence of stuff by employee.

I was wondering how can I include every employee from my table in that query, even if they didn't do anything? I'd like to return 0 if nothing.

Here's my SQL code:

SELECT TB.Date, TB.MONTHS, TB.EMPLOYEES, Count(TB.APP) AS REVIEWED_FILES
FROM (SELECT MONTHPermanentTable.Date, MONTHPermanentTable.MONTHS, MONTHPermanentTable.APP, MONTHPermanentTable.EMPLOYEES FROM MONTHPermanentTable GROUP BY MONTHPermanentTable.MONTHS, MONTHPermanentTable.Date, MONTHPermanentTable.APP, MONTHPermanentTable.EMPLOYEES)  AS TB
GROUP BY TB.Date, TB.MONTHS, TB.EXAMINER_S;

[ranman256]

all queries display fields even when empty.
tho you may want an OUTER join to show items not part of the criteria.

[isladogs]

Using a left outer join linking the Employee table to your other table so it gets data for all employees.
The count field will be blank for those with no records.
If you would prefer it to show 0, use the NZ function. Nz(Count(…),0)