#Error Message

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

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
 
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 said:
Hi Nigel,

Try:

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

Clifford Bass
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
Click to expand...
Click to expand...
 
Hi Clifford

No, that didn't work either. But, I've managed to find a solution:

IIf([HasData],Count(*),"No Data")

Many thanks for your replies and help.

Nigel
 
Back
Top