null values

  • Thread starter Thread starter dave
  • Start date Start date
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?
 
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.
 
Back
Top