How to i run the update query on the table

[Eric]

I create an extra field in the table, bind it to the relevant form (as
in normal form design). Then to show the data. I want to run an
update query on the table so that the data posted by the update query
gets displayed. I need help to run an update query should i create a
query by using query designer and then thru menu i change it to Query
Update Query. After that how to i run the update query on the table

Thanks,

 

[Guest]

Create a query in design view in the usual way, adding just the new field to
the design grid. While still in design view select 'Update Query' from the
Query menu. Then in the 'Update to' row enter whatever you want the new
field to be updated to. Then from the Query menu select Run. You'll next be
prompted to confirm that you want to update the table. Unless you want to
run the query again there is no need to save it.

Ken Sheridan
Stafford, England