An expesion built in a form, "=[field1]*[field2] . Get result but.

[Guest]

I have designed a form that in one of the fields i have built an expression
that figures the total cost from two previous expressions on the same form.
So there are three fields all together that have an expression. These
expressions work great except that the results and the sums of the fields are
not entered into the filed on the table that they are associated with. Why?
How can i get these fields to enter the data into the table?

 

[Allen Browne]

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

The article explains that the result should not be stored in the table,
unless there is a reason why the number should sometimes be different from
the calculated result.

 

[Guest]

will,

There might be a misunderstanding. I don't believe that the data for a
control can be the result of a function and be bound to a field, too. Sounds
like you need to utilize an event to have the data in a field updated from
the results of an expression.

Marvin

 

[Rick B]

As mentioned many many many times in these newsgroups, you should not store
a calcualted result in a table. When you need that number in a form, query,
or report, simply perform the calculation there.

To store the result would be redundant. Also, what if one of the values
changes? How would Access know to update the calculated number?

Make sure to search the groups before posting in the future. You will
almost always find your answer out there in previous posts.

Rick B