What level of detail do you want? I understood you need only a count by year+month. Do you need all records? I think I didn't understand what you want to obtain.

Vlad

>>select str(year(datefield),4)+str(month(datefield),2) as yearmonth ... bla,bla... group by yearmonth
>
>Yes, this was my first try.
>
>However, the group by does not give a direct result. So, that's why I was focusing on another method. I have a tag on the date of the message and I would like to use this technique.
>
>So, for example, I start by doing a SQL like this:
>
>SELECT ADDDATE FROM THREAD;
> WHERE NOMEMBER=lnNumero AND NOCLIENT=lnWeb;
> ORDER BY 1 INTO CURSOR TEMP
>
>This will be a direct result giving me all the dates for a user in a specify forum. So, after this SQL, I now have my first date. Doing GO BOTTOM, will give the last date.
>
>There I have the first and last date which I then use for the month/year repartition.
>
>This is where I am not sure about the technique to use.
>
>Thanks.