Handling Nulls when adding fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dylan Moran - 05 Aug 2005 06:21 GMT

I want to do some currency calulcations on fields on a form and handle any
nulls.

I have read the help and am having some troubles.

Formuals is:

=Nz([SalesRevenue]-[ABCExpense]-[XYZExpense],0)

With a null value in the fields ABCExpense or XYZExpense, the result is 0.

Your assistance is appreciated.

Signature

I may not know VBA inside out, but from the outside I am looking in.
Dylan Moran - Melbourne Australia

Reply to this Message

Dirk Goldgar - 05 Aug 2005 06:30 GMT

> I want to do some currency calulcations on fields on a form and
> handle any nulls.
[quoted text clipped - 9 lines]
>
> Your assistance is appreciated.

You need to wrap each field in Nz, not the whole expression. Like this:

=Nz([SalesRevenue], 0)-Nz([ABCExpense], 0)-Nz([XYZExpense],0)

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Dylan Moran - 05 Aug 2005 06:36 GMT

Many thanks.

> > I want to do some currency calulcations on fields on a form and
> > handle any nulls.
[quoted text clipped - 13 lines]
>
> =Nz([SalesRevenue], 0)-Nz([ABCExpense], 0)-Nz([XYZExpense],0)

Reply to this Message