I have a table with a column called "And" whitch shows the currency values like "£45" ect. I'd like to know how to add up all of the values in the column "And", and then put the currency value into a text box on a form onload.
So mabey something like
Private Sub Form_Load ()
Textbox2.Value = Sum("And" from "Table1")
End Sub
Or if it shouldnt be in Form_Load, tell me. So basically the textbox will always be the right value even if i changed a value while the form was open?
Thanks in Advance, Dan.
So mabey something like
Private Sub Form_Load ()
Textbox2.Value = Sum("And" from "Table1")
End Sub
Or if it shouldnt be in Form_Load, tell me. So basically the textbox will always be the right value even if i changed a value while the form was open?
Thanks in Advance, Dan.