I am currently using the following expression in a query
to add "Null" values

qrIntBuk4RC: (NZ([tbMstLog4rc],0)+NZ([tbMstLog5rc],0))


My Problem follows:
The two fields that this adds ("[tbMstLog4rc]"
and "[tbMstLog5rc]") contain a "Null" if a product has not
yet been requested (and the same as it has been shipped).
In the event that both fields have a Null value I need to
see a Null value in the query (blank cell), showing it
hasn't been requested, rather than the "NZ" value that
would give a 0.

Currently
" " + " " = 0
" " + " " = 0
"2" + " " = 2
"2" + "2" = 4

I need it to calculate

" " + " " =
" " + " " = 0
"2" + " " = 2
"2" + "2" = 4

I guess it would calculate exactly as the AVG command
does, because in that command, Null is disregarded rather
than converted to 0
My main problem is that i am desiging a databast that has
to "look" and "Function" like there original forms

Sorry and Thanks

~Eric