Zero Records Returned

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
p17rb said:
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.
Click to expand...


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

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