calculation in a query returns #Error

[Pat Wright]

For some reason I can't get a simple calculation in a
query to work:

TOTALPOINTS: nz([PRODPOINTS],0)+nz([POINTS],0)

It produces an error if points is a null value.

Any help would be greatly appreciated.

Pat Wright

 

[John Vinson]

For some reason I can't get a simple calculation in a
query to work:

TOTALPOINTS: nz([PRODPOINTS],0)+nz([POINTS],0)

It produces an error if points is a null value.

Odd. If you type Ctrl-G and type

?NZ(NULL)

in the Immediate window, do you get an error, or a zero?

You don't perchance have a user function named NZ?