If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Error Message
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 |
#2
|
|||
|
|||
#Error Message
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 |
#3
|
|||
|
|||
#Error Message
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 . |
#4
|
|||
|
|||
#Error Message
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/For...ports/201001/1 |
#5
|
|||
|
|||
#Error Message
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" wrote: 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/For...ports/201001/1 . |
#6
|
|||
|
|||
#Error Message
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 -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|