Solved: Count Query

[kbsudhir]

HI All,

I want to create a count query to find how many mails I received each month.

The ReceivedDateTime Coloumn stores the mail's received date & time in teh format as below:
"9/16/2008 9:25:05 AM"

Please Guide.

Regards
Sudhir

:dunno :help

[CreganTur]

Create your query, and then click on the Totals button (the Sigma sign). This will add a new row to your query in Design View- the Totals row. For the Totals row for your ReceivedDateTime field, select Count.

HTH:thumb

[kbsudhir]

Thanks Randy,

But this technique shows me all the mails I received in last 6Months i.e from teh day I started capturing the data But I am not getting month on month count breakup ex. 10 in month 9 i.e no of mails in a column & the mnth is teh corresponding column.

Please guide.

Regards
Sudhir

[kbsudhir]

I am able to do it. Below is teh query

SELECT Count(Assigned.ReceivedDateTime) AS CountOfReceivedDateTime, Format([ReceivedDateTime],"m") AS [Month]
FROM Assigned
GROUP BY Format([ReceivedDateTime],"m");


Thanks for all the help

:bow: