co*********@gmail.com wrote:
Can any one please tell me the steps that how to run an update query
on the table
Thank You.
Where? From Code? Manually via the GUI?
To run an update query manually you create a new query, add your table, set
the query type in the menu to UPDATE and then configure the changes you want
to make to the desired columns and then presss the exclamation point button
in the toolbar. If you save an UPDATE query then it can be run simply by
opening it from the db window.
From code you can run a saved UPDATE query with...
DoCmd OpenQuery "QueryName"
or (preferred)
CurrentDB.Execute "QueryName", dbFailOnError
You can also use...
DoCmd.RunSQL "UPDATE SQL Statement"
or
CurrentDB.Execute "UPDATE SQL Statement", dbFailOnError
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com