two questions in one

[hp2222]

Hi i am getting "#error" when value of the sum is null.

any idea?

Also how to modify format so that all the fields would have same decimal point in the number value?

thanks

 

[Aubs010]

in answer to the first part:

=IIf(OR([data1]="",[data1] is null,[data2]="",[data2] is null)=True,"0.00",[data1]+[data2])

Something like that in the control source hopefully might do the trick...

Or just

=IIF([data] is null,"",[data])
or
=IIF(isnull([data]),"",[data])

Not sur eif the last two would work properly...

HOpe it's of some use!

Aubs

 

[CosmoKramer]

Try the Nz function:

=Nz([YourField],0)

will return a 0 if null and allow the sum to work.....

 

[hp2222]

I get #name? for any of these expressions. is it because the source is not recognized?

 

[CosmoKramer]

Try that syntax in an unbound text box, and make sure to replace [YourName] with the actual name of the field from your table/query.....