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).]
Is there away around this?
tia
[This message has been edited by chuckster (edited 10-20-2000).]