Searching for a null

[UT227]

I'm building a database for work that keeps tabs on checks employees are doing. I can build a query showing the activity of each employee. However, when I'm doing a search of dates (I use the BETWEEN command), It will find everyone that has activity. If there is no activity, there is nothing to search for if there is no activity. I need all employees listed with the number of checks done. If someone has no activity, I need it to show "0." I'm having a hard time figuring this out.

[Micron]

Without more information like what tables are involved or seeing the sql it's a guess as to the best solution. You could wrap the number field in the NZ function to return 0:
Nz(somefield, somefield,0).

[CJ_London]

If someone has no activity, I need it to show "0."

As Micron says, need more information.

A possible solution is to left join the employees table to your query on employeeID. This will return null values instead of 0 for those employees without a count, but you can subsequently display 0 instead of null in your form or report using the format property