Hi everyone. I have one table where each record has about 12 'Original Debt' fields. I'm trying to show the total of all the "OrigDebt" fields for each record. I can get this simply by using the below SQL, but if only ONE OrigDebt has a value, the total column is blank. Is there any easy way around this?
SELECT tblMain.ApplicationID, tblMain.strD_PresentLoanHereOrigDebt, tblMain.strD_OtherFinLoanCompOrigDebt, [strD_PresentLoanHereOrigDebt]+[strD_OtherFinLoanCompOrigDebt] AS TotalOrigDebt
Below I'm showing all this with just using two of my "OrigDebt" fields.