Getting a calculation in a form to update a table

[Wes]

Hi I have recently set up a new database but what I need it to do is a simple
calculation in a form, that will automatically update a table but when i set
it up, the form carried out the calculation fine, but it did not enter the
outcome of the calculation in the table. I am clearly doing somehting wrong
i just can't figure out what it is. The table is call Table 1 and the
formula for the calculation is
=[Pad size Rim] - [Pad size Axle], it displays the answer in Field [pad
difference] on the form, but not in the field in the table.

Please Help

Wez

 

[Allen Browne]

Calculating the answer when you need it is the best possible solution.

If you need to see it elsewhere than in your form, create a query, and type
the expression into the Field row. Then use this query whereever you would
have used your table.

The reason this is better is that it cannot go wrong. If you store the value
in the table, and then it doesn't match, you're shot.

More information:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

 

[Tom van Stiphout]

On Thu, 6 Nov 2008 04:43:01 -0800, Wes <[email protected]>
wrote:

That's good, because in the vast majority of cases calculated fields
don't belong in a table. Why? Because they can become out of sync, and
it is very easy to recalculate in a query:
select [Pad size Rim] - [Pad size Axle] as "pad difference"
from Table1

So please delete that field from your table definition and use a query
to calculate.

-Tom.
Microsoft Access MVP

 

[Stockwell43]

Hi Wes,

The guys are correct, the total should not be stored in the table. However,
to add to thier response, if you plan to create a report with these fields
you can also do the calculation there as well. So if no report you have the
query and if you have a report do it in the report.

Good Luck!