Access 2010 table with null field
Posted on 2015-02-18
I have a table I need to sum records on, but one field is keeping me from doing that. It is a field that appears blank, but is in some instance "Null" and others "Not Null". See example below of E&O Tag field:
Part Number Qty Amount E&O Tag
1124087 16800 14112
1124087 -16800 -14112
The Qty and Amount fields should add to zero, but don't because of the E&O Tag field. I have taken the E&O Tag out of the query and it works fine, but I need that field in my results as it sometimes has text in it. I am thinking about an update query, but how do I do that? Update from Null to ...? What is the best way to get this done? Thanks.