Auto-Calculation with null fields

  • Thread starter Thread starter Evan McCutchen
  • Start date Start date
E

Evan McCutchen

I have an Invoices form that has three rows of information, each with a
"quantity" and a "priceperunit" field. Also, each row has a "total" field
that auto calculates the total price of each line. Normally, we only use one
or two rows filled, and all third row fields are Null.

I have a field at the bottom of the form that is called "overallprice" whose
control source is set to "=[Total1]+[Total2]+[Total3]". If all three rows of
data have a "total" figured, then "overallprice" will autocalculate. If any
of the "total" fields are empty, then it will not work. Does anyone have a
solution so that I can have one of the "total" fields empty and still have
the "overallprice" field still calculate?

Thanks!
Evan McCutchen
evan AT radiologyonesource DOT com
 
you may try this way
=nz([total1])+nz([total2])+nz([total3]

Edmun
MCP - Access and SQL Serve

----- Evan McCutchen wrote: ----

I have an Invoices form that has three rows of information, each with
"quantity" and a "priceperunit" field. Also, each row has a "total" fiel
that auto calculates the total price of each line. Normally, we only use on
or two rows filled, and all third row fields are Null

I have a field at the bottom of the form that is called "overallprice" whos
control source is set to "=[Total1]+[Total2]+[Total3]". If all three rows o
data have a "total" figured, then "overallprice" will autocalculate. If an
of the "total" fields are empty, then it will not work. Does anyone have
solution so that I can have one of the "total" fields empty and still hav
the "overallprice" field still calculate

Thanks
Evan McCutche
evan AT radiologyonesource DOT co
 
Back
Top