Or better:

select left(dtos(datefield),6) as yearmonth bla,bla group by 1

Vlad

>>I understand you have a table with a date field and you want to count the records by month. Is it excat? :)
>
>Yes, but per month/year as well. Otherwise, I will end up with messages from January 1997+1998 in the same boat. :)