fidTot= at420 + ai163 + ar091 + mi866 + mi543 + mt592 + as551 + dt683 + dt214 eTot = ed5318 + ed5319 + ed5320 + ed5321 dTot = dt683 + dt214 /* values not calculated aTot + bTot = cTot + bTot = 43048 cTot = 6433 */ oTot = bTot - cTot mTot = mi866 + mi543 + mt592 + as551 nTot = at420 + ai163 + ar091 fidWorth + aTot = getVal(0), bTot = getVal(23), cTot = getVal(19); select aTot, bTot,cTot, dTot,eTot, mTot, nTot, oTot, date(fidCurDate),fidId from fidelity order by fidCurDate Desc;