Re: Total transactions by month

FJB wrote:
> I have searched the newsgroup and do not find exactly what I am
> looking for so I thought I'd ask a very elementary question.
>
> There table has 3970 records for the time period January through July
> 2005. I would like to know how many records per month. I have
> separated the date field into month and year expressions, but cannot
> seem to get the seven numbers I need. Any help would be greatly
> appreciated.
>
> Thanks

SELECT Format(DateFieldName, "yyyymm") AS YrMnth, Count(*) as Qty
FROM TableName
GROUP BY Format(DateFieldName, "yyyymm")

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Loading