Number Problem

[Shawn]

I have a field called Total Price wich gives me the total value of a Job. I need to subtract different fields (HARDWARE COST,STEEL COST,TOTAL LABOUR COST witch are all calculated by formulas) from the total price to get my PROFIT/LOSS.
Now my problem is that if for example there is no hardware cost my hardware cost field is empty which in turn causes my PROFIT/LOSS field to be emply even though there is still LABOUR COST and STEEL COST against that job. If there is a value in all the cost fields then the formula works.

There may be a simple solution to this but I can't figure it out.
Any suggestions would be greatly appreciated.
Thanks Shawn

 

[fredg]

I have a field called Total Price wich gives me the total value of a Job. I need to subtract different fields (HARDWARE COST,STEEL COST,TOTAL LABOUR COST witch are all calculated by formulas) from the total price to get my PROFIT/LOSS.
Now my problem is that if for example there is no hardware cost my hardware cost field is empty which in turn causes my PROFIT/LOSS field to be emply even though there is still LABOUR COST and STEEL COST against that job. If there is a value in all the cost fields then the formula works.

There may be a simple solution to this but I can't figure it out.
Any suggestions would be greatly appreciated.
Thanks Shawn

Look up the Nz function in the VBA help files.

=Nz([FieldA]) + Nx(FieldB) - Nz(FieldC]) + etc.)