sum of all records of a field

[naeem_ul_hussan@hotmail.c]

I am working in VB.net with access database.
i have a table =
SELECT aSaleDate,aRotana FROM BDSS_SALES where aSaleDate=#10/25/2006#

The above query returns more then one records

Now i want to take of field "aRotana"
plz help me in this problem

 

[jmcilhinney]

You can use the Compute method of your DataTable:

Dim sum As Decimal = CDec(myDataTabl.Compute("SUM(aRotana)", Nothing))

 

[cjard]

Almost no point in selecting the ale date since you already know it but:

SELECT aSaleDate, SUM(aRotana) FROM BDSS_SALES where aSaleDate=#10/25/2006# GROUP BY aSaleDate