Run an update query

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

Can any one please tell me the steps that how to run an update query on
the table.

Thank You
 
If you have an update query, you can open it and click the big red
exclamation-mark icon on the toolbar. Or choose Run on the Query menu.

If you want to run it from a macro, use RunSql action.

If you want more control over what happens when you run it, see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

If you don't know how to make an update query, create a normal query, and
choose Update on the Query menu.
 
Anna

(before updating with an update query, make a backup of your .mdb file, just
in case)

Create a new query. Add the table you want to update. Add the fields you
need to select by (i.e., the fields for which you'll provide selection
criteria). Add the fields you wish to update.

Run the query as a selection query to see if you are getting what you
expect.

Modify the query -- convert it to an update query, and add in the value(s)
to which you wish to update the fields.

Run the query (as an update query).

Or maybe you mean something different that I do by "run an update query on
the table"?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top