Adding the value of two fields when value is null

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

I am working in a query. I would like to add the value of two fields (OT and
DT) together in a third field. However, sometimes the value of one field is
null, and Access won't calculate a total.

I don't want to change all of the null values to "0" in the original table
(when both fileds have a value, Access doesn't have a problem calculating the
total) - Any suggestions?

Thank you!
 
NZ([OT],0)+NZ([DT],0)

NZ is a function which will return a value if the input is null.
 
You can use:
ExtraTime: Nz([OT],0) + Nz([DT],0)

IMO, OT, DT, and RG should all create separate records in a related table
with a field that store the TimeType.
 
It worked! Thank you SOOOOO much!

Jellifish said:
NZ([OT],0)+NZ([DT],0)

NZ is a function which will return a value if the input is null.


Laura said:
I am working in a query. I would like to add the value of two fields (OT
and
DT) together in a third field. However, sometimes the value of one field
is
null, and Access won't calculate a total.

I don't want to change all of the null values to "0" in the original table
(when both fileds have a value, Access doesn't have a problem calculating
the
total) - Any suggestions?

Thank you!
Click to expand...


.
Click to expand...
 
It worked! Thank you SOOOOO much!

Duane Hookom said:
You can use:
ExtraTime: Nz([OT],0) + Nz([DT],0)

IMO, OT, DT, and RG should all create separate records in a related table
with a field that store the TimeType.
--
Duane Hookom
Microsoft Access MVP


Laura said:
I am working in a query. I would like to add the value of two fields (OT and
DT) together in a third field. However, sometimes the value of one field is
null, and Access won't calculate a total.

I don't want to change all of the null values to "0" in the original table
(when both fileds have a value, Access doesn't have a problem calculating the
total) - Any suggestions?

Thank you!
Click to expand...
Click to expand...
 
Back
Top