Adding a field with a Null-value

  • Thread starter Thread starter Rolf Rosenquist
  • Start date Start date
R

Rolf Rosenquist

In a form I have 12 fields A, B, C, D... and Sum. After update of one of the
fields, the Sum should be calculated. I do that with code, but get nothing
(Null) for the Sum, if at least one of the fields contain a Null-value.

How can I do a calculation that ignores the Nulls and gives me the sum of
the real numeric values?

/ Rolf
 
That was the right medicine for this problem. Many thanks for the tip!
/ Rolf


Ofer Cohen said:
Try using the Nz function to replace the Null with 0

=Sum(Nz([FieldName],0))

--
Good Luck
BS"D


Rolf Rosenquist said:
In a form I have 12 fields A, B, C, D... and Sum. After update of one of the
fields, the Sum should be calculated. I do that with code, but get nothing
(Null) for the Sum, if at least one of the fields contain a Null-value.

How can I do a calculation that ignores the Nulls and gives me the sum of
the real numeric values?

/ Rolf
Click to expand...
Click to expand...
 

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

if a # then sum, if text leave null 2
Frustration with Looping and Nulls 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
calculating with Null fields 3
Evaluate multiple controls for Null values 4
Sum a field with null value 5
Null Value in Subform Total 4
Turning off "null propagation" when adding fields 1

Back
Top