When using a query to merge three fields and to come up with a sum i.e. IIF([A]=0,0,[A]+[B]+[C]), it return nothing. When I add B and C, I get the correct product, but add in that A, which usually is empty, I get an empty cell.