How do I create a button on my form that adds values of fields the

T

Tom

Hello, I hope someone can help me. If my questions is answered in another
post I would appreciate some direction.

I have an access 2003 form that has some currency fieds. I would like a
command button to add up the fields and populate the result in another field
on the form. This should be updated once the button is pressed.

Any ideas? Thanks!!!
 
T

tina

if the individual currency values are being stored in a table, then also
storing the calculated (total) value in a table violates normalization
rules. recommend you don't do it. instead, just calculate the total value at
runtime, wherever you need it - queries, form, reports.

hth
 
R

redwings

Hello, I hope someone can help me. If my questions is answered in another
post I would appreciate some direction.

I have an access 2003 form that has some currency fieds. I would like a
command button to add up the fields and populate the result in another field
on the form. This should be updated once the button is pressed.

Any ideas? Thanks!!!
Click to expand...

If you mean you have to calculate the total, you only need an unbound
text calculating the totals, and thats it!
 
M

missinglinq via AccessMonster.com

Private Sub CalculateButton_Click()
TotalTextBox = Field1 + Field2 + Field3 '...etc
End Sub
 
Top