total in a form

[aman909]

Hi,

I would like to calculate the total on a form. But the problem is that i need it to calculate from 5 text boxes on a form, but not all this text boxes are filled out depending on a client.

E.g. one client will have 3 out of the 5 text boxes filled out while another will only have 1 out the 5. So i need to be able to work out the total, but the text boxes that aint filled out have to stay empty it cant contain a 0, zero.

what is the best way to be able to do this?

 

[pbaldy]

Sounds like you have a normalization problem with the 5 fields, but you should be able to use the nz function in your calculation to account for the Null fields. More info in VBA Help.