Hi everyone. I have created a query to use when generating a report. I have two fields in my query that I want to add together in an expression, so the sum will show up in one field of my report. The two fields are 2XTotalAmt and 3XTotalAmt. Both are formatted as currency on the table they exist on, and when I view my Query in datasheet view, the numbers in those fields show up in the currency format.
In my query, I created an expression like so: 2X3X: Format(Nz([2XTotalAmt])+Nz([3XTotalAmt]), "Currency")
This works -- however, if both 2XTotalAmt and 3XTotalAmt are Null, I want 2X3X to also be Null (store no value). Is there a way to do that? Right now it is storing $0.00, but I don't want that to show up on my report if the total is zero. If there is no way to make the field store no value, is it possible to have it not show anything in that field on the report?