Zero Records Returned

[p17rb]

I'm trying to find a way to way to have Reports Display a 0 if no records are
returned from my query. I've tried both Select and Crosstab queries. My
current queries return a blank and I need to replace it with a 0. I've tried
Count, DCount, Nz and I don't remember what else. They work great if one or
more records are returned.

thanks much

 

[Marshall Barton]

I'm trying to find a way to way to have Reports Display a 0 if no records are
returned from my query. I've tried both Select and Crosstab queries. My
current queries return a blank and I need to replace it with a 0. I've tried
Count, DCount, Nz and I don't remember what else. They work great if one or
more records are returned.

In a report header of footer section text box, use the
expression:

=IIf([Report].[HasData], Count(*), 0)