Set count to Zero

G

Guest

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!!
 
G

Guest

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

Count function on reports 6
Problem with Count 2
Count on report, based on report, not query. 1
=COUNT() where column is blank/null returns ZERO 1
How to represent a record not found 2
Handling Zero Records in Reports 3
printing count of records 1
How do I sum a count field in Access 2003 Reports 3

Top