null values

D

dave

I have a joined table that will have (at times) a null
value in one of the fields. This causes the totaling to
not work. How can I get the total field to work using
numeric values and sometimes combined with the null value?
 
G

George Nicholson

In query design view:
MyField: nz(SourceTableOrQuery.MyField,0)

The Nz (NullToZero) function: if Argument1 is Null, substitute Arg2. If it
was a text field, you would probably use "" in place of the zero.

HTH,
George Nicholson

Remove 'Junk' from return address.
 
Top