Set count to Zero

S

Stockwell43

Hello,

I have a report that pulls from a query. Everything works fine and looks
good. On the Report Footer, I have a field to count all records in the report
which: Count(*). When I pull the report and there are no records, it show
Error# instead of 0 (zero). Is there a way to make it show Zero if no records
are found?

Thanks!!
 
S

Stockwell43

Worked perfectly!

Thank you Duane!!

Duane Hookom said:
Change the Control Source to something like:
=IIf([HasData], Count(*), 0)
--
Duane Hookom
Microsoft Access MVP


Stockwell43 said:
Hello,

I have a report that pulls from a query. Everything works fine and looks
good. On the Report Footer, I have a field to count all records in the report
which: Count(*). When I pull the report and there are no records, it show
Error# instead of 0 (zero). Is there a way to make it show Zero if no records
are found?

Thanks!!
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display zero value in blank fields of Cross Tab query 0
A03 - count in report footer gives me #Error? 0
Report Group Footer DLookUp 0
if it is null how not to get the #error 1
#Error from Count 3
counting records shown in a report 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
set sub report height 2

Top