SELECT; acctcont.contrib_dt AS contrib_dt,; acctcont.acct_id AS acct_id,; accounts.findex AS findex,; accounts.cashacct AS cashacct,; 'C' AS transType,; IIF(tnMoneyType = 1, acctcont.emat, IIF(tnMoneyType = 2, acctcont.nprofits, 0)) AS nDollars,; 0000.0000000 AS nPrice,; 000000.0000000 AS nshares, ; IIF(ISNULL(crsVestSch.PlanId), acctcont.contrib_dt, crsVestSch.vdate) AS dVestDate, ; INT(YEAR(tdTo) - ; YEAR(IIF(ISNULL(crsVestSch.PlanId), acctcont.contrib_dt, crsVestSch.vdate)) - ; IIF(DATE(YEAR(tdTo), ; month(IIF(ISNULL(crsVestSch.PlanId), acctcont.contrib_dt, crsVestSch.vdate)), ; day(IIF(ISNULL(crsVestSch.PlanId), acctcont.contrib_dt, crsVestSch.vdate))) > tdTo, 1, 0)) ; AS nVestYear, ; aVest(INT(; YEAR(tdTo) - ; YEAR(IIF(ISNULL(crsVestSch.PlanId), acctcont.contrib_dt, crsVestSch.vdate)) - ; IIF(DATE(YEAR(tdTo), ; month(IIF(ISNULL(crsVestSch.PlanId), acctcont.contrib_dt, crsVestSch.vdate)), ; ; day(IIF(ISNULL(crsVestSch.PlanId), acctcont.contrib_dt, crsVestSch.vdate))) > tdTo, 1, 0)) +1 ,1) ; AS nVestPct ; FROM acctcont ; JOIN accounts ON acctcont.acct_id = accounts.acct_id; LEFT OUTER JOIN crsVestSch; ON BETWEEN(acctcont.contrib_dt, crsVestSch.date1, crsVestSch.date2); WHERE invnum = tcInvnum ; AND INLIST(transType, "C", "X", "I", "Y") ; AND ((tnMoneyType = 1 AND emat <> 0) ; OR (tnMoneyType = 2 AND nProfitS <> 0)); AND contrib_dt < tdTo; ORDER BY contrib_dt ; INTO TABLE (lcContribTable)>Renoir,