Adding fields in a report. (1 Viewer)

[chuckster]

I have about ten number fields that I want to add in a report. If there is no value in one of the fields I want that particluar field to be blank. the problem is if I put in the calculation [field1]+[field2] and field2 has no value the result is nothing but if both field have a value it will add it up.
Is there away around this?

tia

[This message has been edited by chuckster (edited 10-20-2000).]

 

[Richie]

Check out the Nz function.

 

[chuckster]

Excellent. Thankyou.