I have field named amount in access tabel i want to grand
total from amount field in text box it will update too
when I enter amount in amount field
plz reply me soon
Thank You
Printable View
I have field named amount in access tabel i want to grand
total from amount field in text box it will update too
when I enter amount in amount field
plz reply me soon
Thank You
Grand total of the "Amount" field:
data1.recordset.movefirst
Do until EOF
total = total + data1.recordset.fields("Amount")
data1.recordset.movenext
Loop
To update your textbox every time, put it in the text1_change event. I think that's what the event's called. Haven't used VB for a while.
Hope that's what you want :)
SQL solution:
select sum(amount) from table