Control equals Calculated Value

[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!!!

 

[Yolanda Buckles]

Can you make the default value for your fields zero?

Hope this helps,

TB

 

[fredg]

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!!!

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