Hi All,
I have a query with one field:
Count: DCount("TAG_NUMBER","H Pm's Closed, 1st TEMP").
It counts the number of records returned by the query "H Pm's Closed, 1st TEMP".
Occasionally, the "H Pm's Closed, 1st TEMP" query returns no records. So, I get no Dcount result. So the query shows no records returned. I need a zero there in that case.
I would like there to be a zero instead of no records, but I can't figure out how to do it. The NZ function is mentioned a lot, but I can't get it to work. Where do I use the NZ, or do I use something else, to get a zero instead of no records? I'm using Access 2003.