I have two queries where the joined fields need to be totaled. however in some cases the field in one coulumn may be blank and have no data. When I try to add the two together, those with the null fields won't add and the total field is blank. what do I do?
I'm sure this question has been asked before but I couldn't find it.
i did try Nz([fieldname],0), it inserted a zero in the blank fields but still didn't add the two fields if one had the zero
I'm sure this question has been asked before but I couldn't find it.
i did try Nz([fieldname],0), it inserted a zero in the blank fields but still didn't add the two fields if one had the zero
Comment