Calculating values

[Kyriakos]

I am not sure whether I posted in the right place but here's the deal: I have a form and a subform based on two tables and on the form I create a mathematical expression concerning a field which is based on another. The results are correct but of course the values in the table remain the same (null). Is there a way to have a formula in the table and then when I create the form based on that table to have the formula ready? BTW where are the data stored if they are not stored in that table?

 

[wazz]

base your form on a query and create your expression (calculation) in a blank field (column) within the query. then you can place it on your form.

calculations are not stored in a table, they are calculated when needed on forms and reports. only store the raw data for the results.