Sum is not working in ADO Recordset



Hi i am having data like this

Mth-Sales
2006/01-5000
2006/01-8000
2006/02-2500

connection

str="Select Sum(Sales) as 'Total_sale' Where Mth like '2006/01' " Group by
Mth"

the recordset return sum as 1

can anybody figure out why ?
.