calculation in a query returns #Error

  • Thread starter Thread starter Pat Wright
  • Start date Start date
P

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
 
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?
 
Back
Top