calculations

[fqb34r]

Hi

I have 8 fields that i need to add up to find the total amount now its fine when all 8 fields have an amount in them but one is missing nothing adds up can someone help me with this problem

What i have done is in my form in the field total clamed I have entered the following in the control source box =[cost]+[cost1]+[cost2]+[cost3]

Kevin

 

[fqb34r]

thanks i now have a new direction to work on and can see the hole data base in a new way i will have a play and see were i get thanks for you time

kev

 

[gameover]

Hi Joe,

I changed the property to number and now its working perfectly fine.

Thanks for your help!!!!!