SELECT IIF(ISNULL(MsBench.CatName), PADR("Other",25," "), MsBench.CatName) as Category, ; SUM(crsAssetsLiab.Asset) as Asset, ; 0.000 as AssetPct, ; SUM(crsAssetsLiab.Liability) as Liability, ; 0.000 as LiabPct ; FROM crsAssetsLiab ; LEFT OUTER JOIN Mornstar ; ON crsAssetsLiab.Acct_Id = Mornstar.Acct_Id ; LEFT OUTER JOIN MsBench ; ON MornStar.CatId = MsBench.CatId ; GROUP BY 1 ; INTO CURSOR crsBalByCat READWRITE ; HAVING Asset <> 0 OR Liability <> 0