Count Error Message

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

Guest

I'm using =Count(*) in a report footer to count the total number of records,
but I'm getting a #Error result. What's wrong?
 
Is the control actually in the Report Footer or the Page Footer?
Does the report return any records?
If the report is not returning any records and you want to display 0 then
use
=IIf([HasData], Count(*), 0)
 

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

A03 - count in report footer gives me #Error? 0
Count Function 5
#Error from Count 3
counting records 0
#Error Message 2
Count or sum unique records in a report's group footer in Access 2 2
Multiple level counts 7
Count In Group Footer 1

Back
Top