• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Calculate the values of a database column

Calculate the values of a database column

Calculate the values of a database column

API Declarations


Dim rs as new adodb.recordset
Dim a,c,t as long





Rate Calculate the values of a database column

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

set db=createobject("ADODB.connection")
set rs=db.execute("select from tablename order by fieldname")
do until rs.eof
a=val{rs.fields("Fieldname"))
c=a
t=c+t
rs.movenext
loop