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