• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• summation function of column using msql codes

summation function of column using msql codes

summation function of column using msql codes

Rate summation function of column using msql codes

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

rs.Open "colector", con, adOpenDynamic, adLockOptimistic
    rs.MoveFirst
    
        If rs.BOF = True Then
            Label1.Caption = .Fields("principal")    'store the 1st row
        Else
        Label2.Caption = 0 'return the 2nd storage to 0
        Label2.Caption =  val(Label1.Caption) 'pass value to 2nd storage
        While Not rs.EOF
            Label2.Caption = val(Label2.Caption) + val(rs!principal) 'add the remaining value in the selected field
            rs.MoveNext
        Wend
        End If
    
      rs.Close