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