adding Nulls

C

Chris

How do you go about adding or summing columns were some
columns are empty (Null?)?
 
D

Duane Hookom

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

StCyrM

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