Hi, I created a query for my portfolio management practice that produces each account and the total amount of Money Markets, Tbills and cash equivalents each client has in their account. Some clients don't own all three, so this leaves a blank space in the query. I am trying to add these three totals together to get a total "cash" value they are holding. When I tried adding them, the ones with blank spots wouldnt add but the rest worked. I used the IIF(IsNull(Field),"0",Field) to produce zeros in the blank spots. But now when I go to add them together it produces something extremely weird. I am entering it by Total: [Field1]+[Field2]+[Field3] and it seems to not be doing math and producing a number that has nothing to do with the fields its supposed to be adding. Does anyone have an idea of what could be going wrong?