Thursday, 19 September 2013

Format the date - on the basis of month MSACCES

Format the date - on the basis of month MSACCES

I wanted to query the msaccess database - to get the data something like
Month Count Jan 4 Feb 2
i am having columns in my database namely [ Taskdate and count ], how to
filter the date on the basis of month and get the count assoicated with
that month??
SELECT Format([Taskdate],"dd/mm/yyyy") AS MyDate , count (Taskcount)
FROM Table1 GROUP BY Format([Taskdate],"dd/mm/yyyy")

No comments:

Post a Comment