>SELECT CONVERT(CHAR(4),YEAR(MyTable.MyField))+REPLACE(STR(MONTH(MyTable.MyField),2),' ','0') AS lcChampNumero, > COUNT(*) AS Compte,MIN(MyTable.MyField) AS AddDate > FROM MyTable >You need to group by some field and also CHAR and CONVERT are SQL Server functions. Although it's easy enough to find VFP replacements.