[البراء]

بسم الله الرحمن الرحيم
بارك الله فيك تم تجربة الكود وشغال 100 % 100
لتصبح جملة sql هكذا

كود :

TRANSFORM Sum(EMP.SALARY) AS SumOfSALARY
SELECT EMP.EMPID AS Employee, EMP.EMPNAME AS [Employee Name], Sum(EMP.SALARY) AS [Total Recieved], Count(EMP.EMONTH) AS [Months Number]
FROM EMP
WHERE (((EMP.[emonth]) Between #1/1/2012# And #4/1/2012#))
GROUP BY EMP.EMPID, EMP.EMPNAME
PIVOT Format([EMONTH],'mm-yy');