SUM function

[digit]

Dear Friends,
im very new in MS ACCESS that why i wanna aski you a question.
I have a form with 2 text boxes - currency wich is [Amount] and [SubAmount] from table Amounts.
How can i create a text box in this form wich can Sum [Amount] and [SUbAmount] in a text box and display.

Thanks
Veselin

 

[MStef]

Hello Veseline!

Look at "DemoSumAmountA2000.mdb"

 

[digit]

Thanks

Many thanks,
but how can i write this in a table?
Is it possible?

 

[neileg]

You don't store calculated values in a table. You calculate them in a query or a form when you need them.

If you store a calculated value and one of the fields on which it is based changes, the calculated value is then wrong.

 

[digit]

Thanks, but then how can i store that?

 

[MStef]

Ok, neileg is right, but if you want this, here it is.

 

[neileg]

Why do you want to store it? You can calculate it on the form.

= [Amount] + [SubAmount]