Update query-multiple fields,1 with data, 1 without

[MarkGardner]

Access2007- Building a query to handle future input...

I run an update query that does what it is supposed to do and gives the proper values.

THEN I add a one more field to the source with the builder using + that has no data in it yet, the query fails and gives blanks, even though one of the fields in the source has data in it.

I would think that the "no data" field would be considered 0.00 value and be added together to the field that has values giving at least the value of the field with values as a result of the query.

Is there a setting somewhere that I need to change so that the no value and the value would be combined? I am using the builder to combine the values in the query.

Thanks.

 

[Dennisk]

if any field in an expression such as yours is null, then the result of the calculation will be null. What you need to do is use the NZ() NullToZero function for each value

ie =NZ(Value1,0) + NZ(value2,0)

 

[Brianwarnock]

I would think that the "no data" field would be considered 0.00 value

Null exists inorder that you can differentiate between novalue and 0 as this can be important.

Brian