Can an expression update a table, I know that in a form a query w.

I am trying to update a table using an expression in a form. The value comes
up correcly after all the data is entered. However, these fields do not show
up in the corresponding table. I need to know how to update my table and
still get the calculations correct.

See:
Calculated fields
at:
http://members.iinet.net.au/~allenbrowne/casu-14.html
for an explanation of when and how to store a calculated result.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"04Ram" wrote in message
...
I am trying to update a table using an expression in a form. The value
comes
up correcly after all the data is entered. However, these fields do not
show
up in the corresponding table. I need to know how to update my table and
still get the calculations correct.

In your query design you have to right mouse in the table area, select Query
Type and select 'update query' This is the tool to update the fields in a
table based on your expression

sample SQL
UPDATE Table2 SET Table2.Cost = [qty]*[unit];

Table2 has fields qty, unit,. cost as well as id, description etc

You can include a WHERE clause if you only want to update particular
records.


"04Ram" wrote in message
...
I am trying to update a table using an expression in a form. The value
comes
up correcly after all the data is entered. However, these fields do not
show
up in the corresponding table. I need to know how to update my table and
still get the calculations correct.