How to refer to a query that returns no records

D

D2

It's been a while, so maybe I just forgot how to do this ...

I have a report based on a query, and a subreport based on its own query.
The parameters for both queries are obtained from a form.

If the the query for the subreport returns no records, how do I refer to
that on the main report? I want to make a calculation on the main report
that would add zero if there are no records in the subreport. I keep getting
the dreaded #error or #name thing.

Thanks!

DeeDee
 
Top