Hola
Primera noticia para mi, no conocia esa palabra.
Pero me parece que faltaria esto:
Código SQL
[-]
TRANSFORM SUM(ssQuantity) AS VENTAS
SELECT ssClientPartNumber, ssQuantity
FROM aaShipSchedule
WHERE ssShipToId='P' AND ssScheduleDateTime BETWEEN #01/01/2007# AND #11/30/2007#
GROUP BY ssClientPartNumber, ssQuantity
ORDER BY ssClientPartNumber
PIVOT DATEPART("d",ssScheduleDateTime);
Tal vez sirva.
Saludos