I’ve created a crosstab query where only some of the fields in the columns have values. The fields with no value are showing blank or a $0.00. The tables that the query is made from have all the fields filled with a value or $0.00 so I don’t understand why I have some empty fields and some fields that are $0.00 in the query. Anyway, how do I make the fields that contain no value either blank or zero, either in the query or in the report I’m making from the query?
Hope that makes sense. Thanks.