Sum is not working in ADO Recordset

From: Max <Max@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 18 Oct 2007 21:58:42 -0700

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 ?
.

Follow-Ups:
- Re: Sum is not working in ADO Recordset
  - From: Bob Barrows [MVP]

Prev by Date: Re: Can I from VFP (Visual foxpro) catch the Events of ADO Recordset?
Next by Date: Re: Sum is not working in ADO Recordset
Previous by thread: Can I from VFP (Visual foxpro) catch the Events of ADO Recordset?
Next by thread: Re: Sum is not working in ADO Recordset
Index(es):
- Date
- Thread