Control equals Calculated Value

  • Thread starter Thread starter Kristen
  • Start date Start date
K

Kristen

I have a control (TotalHours) with it's control source
property set to (=[ProjectTeamCosts]+[GeneralLabor]+
[SpecialtyItems]+[ExteriorFraming]+[InteriorFraming]+
[Rocking]+[Taping]+[AcousticalCeilings]+[Lathing]+[Plaster]
+[Fireproofing]+[IntumescentFireproofing]+[MillShop]+Form!
Painting). This gives me the correct number once the user
has entered a value in EVERY single one of those fields.

What can I do to make it give me the running total in the
control (TotalHours) as someone is entering those values
into the various fields? And how can I make it give the
total if not all the fields are filled in? Say there are
no ExteriorFraming hours, but someone is too lazy to put
in a zero. I've noticed that if you leave a field blank,
it won't give you the total.

Thank you in advance for your help!!!
 
I have a control (TotalHours) with it's control source
property set to (=[ProjectTeamCosts]+[GeneralLabor]+
[SpecialtyItems]+[ExteriorFraming]+[InteriorFraming]+
[Rocking]+[Taping]+[AcousticalCeilings]+[Lathing]+[Plaster]
+[Fireproofing]+[IntumescentFireproofing]+[MillShop]+Form!
Painting). This gives me the correct number once the user
has entered a value in EVERY single one of those fields.

What can I do to make it give me the running total in the
control (TotalHours) as someone is entering those values
into the various fields? And how can I make it give the
total if not all the fields are filled in? Say there are
no ExteriorFraming hours, but someone is too lazy to put
in a zero. I've noticed that if you leave a field blank,
it won't give you the total.

Thank you in advance for your help!!!
Click to expand...

Look up the Nz() function in VBA help.
=Nz([ProjectTeamCosts],0)+Nz([GeneralLabor],0)+ etc......
 
Back
Top