>>I have a table that looks like this:
>>
>>

>><b>artnr    date</b>
>>2        1999-04-01
>>2        1999-05-01
>>2        1999-05-01
>>3        1999-04-01
>>
>>And I want to have make something to get something like this
>>
>><b>artnr    Jan     Feb     Mar     Apr     May     ...    Dec</b>
>>2         0       0       0      1       2
>>3         0       0       0      1       0
>>

>>
>>Anyone who can give some clues how to write the SQL-command? I could problably write some code to fix it, but there ought to be some cunning SQL-phrase that would take care of it for me.
>>
>>/Pierre Unge, Sweden
>
>How about:
>
>SELECT artnr, ;
> COUNT(MONTH(date)=1) AS Jan, ;
> COUNT(MONTH(date)=2) AS Feb, ;
> etc ;
> FROM MyTable GROUP BY artnr

Hi Fred,
Close, but that one gives the following result

<b>artnr    Jan     Feb     Mar     Apr     May     ...    Dec</b>
2         3       3       3      3       3
3         1       1       1      1       1

/Pierre