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
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