To change a select Query to an update Query

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

Guest

I have been told to create a new query and change it to an update query.
Refer to my question Can I sort database by year/month/day17/11/05 maud0361
answered by Allen Browne. I don't know haw to do that as I cannot find a menu
with this option. I am using Access 97
 
Open the query in design view.
Click the icon that has two sheets offset to the lower left and a down
arrowhead. Select Update Query.
Fill in the Update To: row with the new information for the fields you want
to update.
NOTE - Always run it as a select query to determine that the records
returned are indeed to be updated and not all records in the database.
 
When you open the query in design view, in the menu bar select Query you'll
see a list of query type to change your query to
Update query , append , create table , Select query

Select the update query, you'll notice that the design will change, and on
the buttom you have a row were it say, update to: enter the values there

Before you try anything Bak up your data
 
Back
Top