adding Nulls

  • Thread starter Thread starter Chris
  • Start date Start date
Using Sum([ColumnFieldName]) should not be affected by Null values. Are you
attempting to sum across fields/columns in a single record? This generally
suggests a non-normalized table structure.
 
Hi Chris

Lookup the NZ function in Help.
Typically the function would take this general expression:
=NZ([myField],0)
where if your field is null then a value of zero becomes the value of the
variable

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Back
Top