Sum()

[DS]

Hi,
When using the Sum() Function it works fine as long as there is a record
present. When there is no record present I get the #Name? message. Hw
do you make the field default to zero when there is no record present?
Thanks
DS

[Mike Turco]

Re: Sum()


"DS" <bootybox@opton line.net> wrote in message
news:LyQed.313$ 3_5.114755@news 4.srv.hcvlny.cv .net...[color=blue]
> Hi,
> When using the Sum() Function it works fine as long as there is a record
> present. When there is no record present I get the #Name? message. Hw
> do you make the field default to zero when there is no record present?
> Thanks
> DS[/color]

Something like this:

iif(isnull([field]), sum([field]),"No Records Present")

[smitty mittlebaum]

Re: Sum()

DS wrote:[color=blue]
> Hi,
> When using the Sum() Function it works fine as long as there is a record
> present. When there is no record present I get the #Name? message. Hw
> do you make the field default to zero when there is no record present?
> Thanks
> DS[/color]
This MIGHT help:
=NZ(sum([fldToSum]),0)