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

[Guest]

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!!!

 

[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

 

[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!!!

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

 

[missinglinq via AccessMonster.com]

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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com