default query result

[stickandrock]

I have a query that counts on a field. There are no matches in my critera so
it results in a empty output. How do I show a 0 in the result if no records
are found

 

[NetworkTrade]

Create a new column.

The Nz function is used to covert a Null to another value. If the variable
or field is not null, it will use the actual value. It it is, it will use
the substitute value. In this case, use 0.

Let's say your existing field/column name is "Emp Base Pay Rate" , then
you would set up the new column like this:

Base Pay: Nz([Emp Base Pay Rate],0)

now the column Base Pay has the results you want....