My Sourcetable >--------+-------+-------+------+ >iID |cArt |cColor |iUnits| >--------+-------+-------+------+ > |Cars |red | 10| > |Cars |blue | 5| > |Cars |green | 2| > |Jeeps |red | 3| > |Jeeps |blue | 1| > |Jeeps |green | 4| > |Vans |red | 2| > |Vans |blue | 0| > |Vans |green | 0| > >The Targettable: Target.dBF >--------+-------+----------+----------+----------+ >iID |cArt |iRed_Units|iBlue_Unit|iGreen_Uni| >--------+-------+----------+----------+----------+ > |Cars | 10| 5| 2| > |Jeeps | 3| 1| 4| > |Vans | 2| 0| 0| > >SELECT iID, cArt, ; > SUM(IIF(cColor="red", iUnits, 0)) AS iRed_Units, ; > SUM(IIF(cColor="blue", iUnits, 0)) AS iBlue_Unit, ; > SUM(IIF(cColor="green",iUnits, 0)) AS iGreen_Uni ; > GROUP BY cArt, 1 > FROM (lcDPFE_TabSource) ; > INTO TABLE "Target" >>My SQL idea not work right. I think, GROUP BY reduced the Resultrecords, but IIF() add the records again.