#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

[Clifford Bass via AccessMonster.com]

Hi Nigel,

Try:

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

Clifford Bass

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

[Clifford Bass via AccessMonster.com]

Hi Nigel,

Hmmm.... I presume you added the missing paranthesis that I missed at
the end. Try this instead:

=IIf(IsError(Count(*)), "No Data", Count(*))

Clifford Bass

Nigel wrote:
>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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201001/1

[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

> .
>

[Clifford Bass via AccessMonster.com]

Hi Nigel,

Glad I was able to help. The HasData is not something I have used in
the past. Good to know about it! Thanks for posting your solution!

Clifford Bass

Nigel wrote:
>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

--