i want to sum one column in the database using Visual Basic 6

[zorcetto]

hi....
plz help me
i have table in database using access 2003 ,wanna make summation 2 column in it
so 1-which type of data choose (microsoft data grid...or etc)
2- the code entering in sub command to do the summation


so plzzz helpp mee .....

[jamesd0142]

hi....
plz help me
i have table in database using access 2003 ,wanna make summation 2 column in it
so 1-which type of data choose (microsoft data grid...or etc)
2- the code entering in sub command to do the summation


so plzzz helpp mee .....

First you will need to make a database connection and simply pass the sql statement:

select sum(<columnname>) from <tablename>

[zorcetto]

First you will need to make a database connection and simply pass the sql statement:

select sum(<columnname>) from <tablename>

thank u James ...
but i wanna more details in code as total ....
my program is that r 2 text box
text1 and text 2 and one sub command
wanna make code
as entering the value in text 1 recorded in database
and viewing the summation in the column in the database
+ i tried this code after connectiing the database
it gaves me "error " so help me
and thanks

[jamesd0142]

thank u James ...
but i wanna more details in code as total ....
my program is that r 2 text box
text1 and text 2 and one sub command
wanna make code
as entering the value in text 1 recorded in database
and viewing the summation in the column in the database
+ i tried this code after connectiing the database
it gaves me "error " so help me
and thanks

what was the error you recieved?
Your datatype must be 'integer' or 'number'...etc to get the sum.