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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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
 
Back
Top