select sum in dao

hi,

how do i perform a select sum in DAO? I've tried using the code below but i received an error:

sql="SElect sum(fieldname) as result from table1"
returnvalue = Data1.Database.Execute(sql)

Thanks in advance

And what, pray-tell, is the error ?

Quote:

---

sql="SElect sum(fieldname) as result from table1"
returnvalue = Data1.Database.Execute(sql)

---

Do you know that "returnvalue" should be a recordset object?
so what you should do is:

VB Code:

Set returnvalue = Data1.Database.Execute(sql)
Debug.Print "The sum is: "; returnvalue("result")