select sum in dao

[tonio]

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

[plenderj]

And what, pray-tell, is the error ?

[Gush]

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:

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