ник: ShadowOfSun
Через перекрестный запрос
у меня это сделано так
TRANSFORM Sum(qwrInterimKPISecond_1.Pallet) AS [Sum-Pallet]
SELECT qwrInterimKPISecond.Date
FROM qwrInterimKPISecond INNER JOIN qwrInterimKPISecond AS qwrInterimKPISecond_1 ON qwrInterimKPISecond.Group = qwrInterimKPISecond_1.Group
WHERE (((qwrInterimKPISecond.Date)>Date()-260) AND ((IIf([qwrInterimKPISecond_1]![Date]<=[qwrInterimKPISecond]![Date],True,False))=True))
GROUP BY qwrInterimKPISecond.Date
ORDER BY qwrInterimKPISecond.Date
PIVOT qwrInterimKPISecond.Group;
|
?? а зачем Exel нужен?