TRANSFORM Sum(sales_order.quantity) AS ¼ÅÃÇÁTMFBYKGs SELECT sales_order.invoice_id, sales_order.Date, Day(sales_order.Date) AS Çѹ·Õè, Sum(sales_order.quantity) AS ¼ÅÃÇÁTMFBYKG FROM sales_order WHERE (((sales_order.Date) Between Forms!SalesReports!startDate And Forms!SalesReports!enddate) And ((sales_order.product_id) In ('101','101S','103','103D','104','105','106','201','202','202TPC','204','205','P0','P1','P2'))) GROUP BY sales_order.Date, sales_order.invoice_id PIVOT sales_order.product_id In ('101','101S','103','103D','104','105','106','201','202','202TPC','204','205','P0','P1','P2');