Sum for Non Zero

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I have a text box on a form called it_est_total.
The control source right now is =[development]+[middle_apps]+[b2b]+
[data_warehouse]+[qa]+[other]+[prod_support_ba]+[prod_support]+[ivr_hours]

This is fine if all text boxes have a number entered. I do not have the
default set to 0 on all of these. They are all blank. I need to keep it
this way.
However, I want the text box it_est_total, to total even if all the fields
are not entered.

Can someone help with this code? Thank you.
 
=Nz([development],0)+Nz([middle_apps],0)+Nz([b2b],0)+Nz([data_warehouse],0)+Nz([qa],0)+Nz([other],0)+Nz([prod_support_ba],0)+Nz([prod_support],0)+Nz([ivr_hours],0)
 
THANKS!
=Nz([development],0)+Nz([middle_apps],0)+Nz([b2b],0)+Nz([data_warehouse],0)+Nz([qa],0)+Nz([other],0)+Nz([prod_support_ba],0)+Nz([prod_support],0)+Nz([ivr_hours],0)
I have a text box on a form called it_est_total.
The control source right now is =[development]+[middle_apps]+[b2b]+
Click to expand...
[quoted text clipped - 7 lines]
Can someone help with this code? Thank you.
Click to expand...
Click to expand...
 
Back
Top