Calculation

[ddrew]

I wonder if someone can point me in the right direction with a calculation problem. I have never done calculations in access before but want to make a balance sheet for a club account that I am designing. Very much in its trial stages, I have a form with three currency text boxes in it, set up as continuous. MoneyIn and MoneyOut are in the main form whilst Total is in the footer. All I want is to be able to put in a value in MoneyIn or MoneyOut and for the Total to update. Problem! I dont have a clue where to start!

 

[adamgoossens]

Hi,

Creating a calculated field is a piece of cake. In your Total textbox set your control source to the following:

=SUM([MoneyIn])

That will provide you with the sum of the MoneyIn field for every record in your data source. You're not limited to single fields, things like this are also legit:

=SUM([MoneyIn] - [MoneyOut])

...for example. That will first subtract MoneyOut from MoneyIn in every record, then add the results together for your total.

Good luck,
-Adam.

 

[ddrew]

Your'e right it is easy, just never done it before. I need to do a requerry on the total box. Is it better to put it in before or after update or is there a better one?