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

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

Guest

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