how do i handle report from a query that returns no records? (1 Viewer)

[martinr]

A have a report that is based on a query that works fine when the query returns records.
However if the query (legitimately) returns no records then the report fields (numeric) are blank.
How can i get the query or report to show either "0" or "no data" when no records are returned? I have tried the NZ function but that didn't work so i don't think that is the right approach here?

 

[GinaWhipp]

Here are two ways...

http://access.mvps.org/access/reports/rpt0006.htm

 

[martinr]

Thanks Gina,
I followed the access-diva link but not sure which of the items you are referring me to?
I still need to open and display/print the report to show that no records were returned...

 

[GinaWhipp]

Not the Access Diva link the one above. And why can't you just tell them no records to display?