Access 07 -- automatic calculation of difference

[GeorgeChr]

Hi, I am creating a table in 07 and I want my table to be able to calculate the difference between two amounts. I have the column "price" which shows the total amount, another one called "money paid" which shows how much of the total amount they have paid so far and the third is "money owed" which is the difference that i want to be calculated automatically.
Do you know any way to do this??

 

[Rabbie]

It is not good practice to hold calculated values in a table. You can always calculate them when you need to display them in a query,form or report.

Remember that the users should never see the table, just the results from the table that you display in a form or report.

 

[GeorgeChr]

It is not good practice to hold calculated values in a table. You can always calculate them when you need to display them in a query,form or report.

Remember that the users should never see the table, just the results from the table that you display in a form or report.

Ok thank you for that, but since that i am new to access can you tell me a way to do what i want if i create a query?

 

[Rabbie]

In the query design Grid insert a column with [price]-[Money Paid].

As you are new to Access I would strongly reccommend you search this forum for Normalization and database design. You may also find useful links if you google for this as well

 

[neileg]

Create a query based on your table. Create a new calculated field by entering in a column name cell the following:
MoneyOwed: [Price] - [Money Paid]

Edit: Snap!

 

[edreamers]

i am going through the same problem but i want to save results in table. can you help me and tell me how i can save the result of calculated field in table.