adding Nulls

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

How do you go about adding or summing columns were some
columns are empty (Null?)?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

including null values in a sum query (non-SQL programmer) 2
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
count Iif is not null 1
Null value not adding in expression 1
Subquery Issue 1 5
Turning off "null propagation" when adding fields 1
CrossTab Query with Min 3
NULL problem with Created table 1

Back
Top