Hi Willem,

the query i have used in sql is

SELECT DATEPART(YY, CHECKINTIME) AS Year, DATEPART(MM, CHECKINTIME) AS

Month, DATEPART(D, CHECKINTIME) AS 'Date', SUM(UPLOADLNCNT)

AS 'Total Lines', TRUSTID

FROM DEPTABLE

GROUP BY DATEPART(yy, CHECKINTIME), DATEPART(M, CHECKINTIME), DATEPART(D,

CHECKINTIME), TRUSTID

ORDER BY Year DESC, Month DESC, 'Date' DESC

and i tried the examples, but still i am getting error.

Please help me on this