I have created a simple calculated field in my query that merely adds three fields, all of which are in the same query and/or table. Two of the fields are also calculated fields and the third is a field from the table. I have named the field as TOTAL. The problem is that whenever a returned record has a value in the 3rd field, the TOTAL does not calculate--the TOTAL field is blank. However, when there is a value in one of the other 2 fields, and not in the 3rd field, the TOTAL field does calculate properly.
This is such a simple calculated field, but I cannot get it to work. I have checked the field properties and can find nothing wrong and no error messages are given. What am I probably doing incorrectly?