How can I add another sum column here to be placed on another text box?

jairus2

Here is my code and its finally working. my only problem now. is how can i add another column to add. and put it to another textbox

Expand|Select|Wrap|Line Numbers

 
Private Sub Form_Load()
 
Dim MyCon As New ADODB.Connection

Dim jai As New ADODB.Recordset

Dim sConnect As String
 
sConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source=" & _

App.Path & "\db1.mdb"
 
MyCon.Open sConnect

jai.Open "select sum(t15) from survey", MyCon, adOpenDynamic, adLockPessimistic

txt15.Text = jai.Fields(0)

jai.Close

MyCon.Close
 
End Sub

Dököll

That's half the battle, jairus2... Can you simply go to design mode in your db and add a column there, then in VB you can say Text16...

How 'bout that?

How can I add another sum column here to be placed on another text box?

re: How can I add another sum column here to be placed on another text box?

Similar Visual Basic 4 / 5 / 6 bytes

/bytes/development

/bytes/it

/bytes/about