Hi Clifford

I tried inputting your suggestion into the unbound box but when I get a
record with no data I still get thge #Error message.

"Clifford Bass via AccessMonster.com" wrote:

Hi Nigel,

Try:

=IIf(IsError([EyNumber]), "No Data", Count([EyNumber])

Clifford Bass

Nigel wrote:
I have created a calculation to count the number of people and placed it in
the Name Footer: =count([EyNumber]) and called the unbound box, CountNames.
When there are no results it returns the #Error message. How can I remove
this error message and display a message like, "No Data", or display the true
results of a count? I have tried using the IsError function but can't seem to
get it to work.

Thanks

--
Message posted via http://www.accessmonster.com

.