Blank result for a simple formula???

[Moxioron]

Hello all.

Today has been plagued with weird simple problems...

Anyway, here is a simple formula:
Total$BalSameRate: [qry_Reprice - Stay at Same Rate - A+]![SumOfBalance]+[qry_Reprice - Stay at Same Rate - E]![SumOfBalance]+[qry_Reprice - Stay at Same Rate - B]![SumOfBalance]+[qry_Reprice - Stay at Same Rate - C]![SumOfBalance]+[qry_Reprice - Stay at Same Rate - D]![SumOfBalance]+[qry_Reprice - Stay at Same Rate - E]![SumOfBalance]

Only A+ and E have actually data at this point, but they all will evenutually have data.

Because A - D have no data, would this result in a blank result when I run the query?

Thanks.

 

[boblarson]

You need to handle NULL values. Adding a NULL to anything makes it NULL.

Nz([qry_Reprice - Stay at Same Rate - A+]![SumOfBalance],0)+[

And you have to do that for each one of them.

 

[Moxioron]

thank you sir. Worked.