Count Error

  • Thread starter Thread starter Good Intentions
  • Start date Start date
G

Good Intentions

I have a report which, based on a query, will tell me how many Courses
have incomplete information grouped by staff member. I use this
report to send to staff so they can submit the missing information for
courses they are responsible for. At the bottom of the form, I have a
=count([COURSEID]) so I can see how many courses are not complete for
each staff member.

I find that if everything is complete, for a particular staff member,
instead of showing a total count of 0, I get #error. What do I need
to add to my control source so the report will show a total of 0
instead of #error.

Thank you.
 
This is probably due to the fact that [CourseID] is NULL in
the case you describe. There may be a more straighforward
way than the following, but you can try an Immediate If
statement:

IIF(IsNull([CourseID]=True),0,Count([CourseID]))

Danny
 
Back
Top