How to display a 0 for a empty record?

If a report yield 0 record, I will get an #error message on a
calculation field. How to display a 0 instead of #error on that field?

Thanks.
Perry

re: How to display a 0 for a empty record?

perryche@yahoo.com wrote:[color=blue]
> If a report yield 0 record, I will get an #error message on a
> calculation field. How to display a 0 instead of #error on that field?
>
> Thanks.
> Perry
>[/color]
See if NZ() will work. Ex:
=NZ([Current],0) + NZ([Previous],0)

re: How to display a 0 for a empty record?

"Salad" <oil@vinegar.com> wrote in message
news:OU9ce.1134$GQ5.49@newsread1.news.pas.earthlin k.net...[color=blue]
> perryche@yahoo.com wrote:[color=green]
>> If a report yield 0 record, I will get an #error message on a
>> calculation field. How to display a 0 instead of #error on that field?
>>
>> Thanks.
>> Perry
>>[/color]
> See if NZ() will work. Ex:
> =NZ([Current],0) + NZ([Previous],0)[/color]

HasData property might help. Check Access help file.

John