>SELECT item, descrip, extprice, invdte, YEAR(invdte) as invyear FROM artran99 UNION ALL select item, descrip, extprice, invdte, YEAR(invdte) as invyear FROM arytrn99 ORDER BY item INTO TABLE invdata > > >SELECT item, descrip, SUM(IIF(invyear = YEAR(DATE()),extprice,0)) as CurrentYear, SUM(IIF(invyear = YEAR(DATE())-1,extprice,0)) as OneYearAgo, SUM(IIF(invyear = YEAR(DATE())-2,extprice,0)) as TwoYearsAgo, SUM(extprice) as YTDTotal FROM invdata GROUP BY item,descrip >