#Error Message

[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

 

[Nigel]

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.

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

 

[Nigel]

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