I need to get a total of a specific column of a table of access db in a text box in my visual basic application. What should be the code? I am using adodc to connect with the database.
Help urgent please..........

Re: How to geta total of a column of access in visual basic 80 80

Simply try using SUM(column_name) using SQL query.

Re: How to geta total of a column of access in visual basic 80 80

Would you please explain a bit more? I am not so expert in codeing. In formload i want to get it. Table name is report, Db name rate. So then......what?

Re: How to geta total of a column of access in visual basic 80 80

try this code. hope this will help you.........

Dim db As Database
Dim rs As Recordset
Dim tot As Double

Set db = OpenDatabase(App.Path & "\rate.mdb")
Set rs = db.OpenRecordset("report", dbOpenTable)

tot = 0

If rs.RecordCount > 0 Then
    rs.MoveFirst
    While Not rs.EOF()
        tot = tot + rs!basic_pay
        rs.MoveNext
    Wend
End If

Text1.Text = tot
Re: How to geta total of a column of access in visual basic 80 80

in your sql query...

SELECT SUM(<column_name>) as SumOfColumn from <tablename>

Re: How to geta total of a column of access in visual basic 80 80

many many thanks to all. thistime shuvi's code works well. thx again shuvi.

Re: How to geta total of a column of access in visual basic 80 80

Querying is better than looping on a recordset since this will take a certain amount of time...

Lets just say you have 100,000+ records, then you will count them 1 by 1?

Re: How to geta total of a column of access in visual basic 80 80

many many thanks to all. thistime shuvi's code works well. thx again shuvi.

glad to hear that. but cometburn's syntax is also correct. you can apply that also.
(completely upto you).

ok....
if u got your answer then mark this thread solved.

regards
Shouvik

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.