To change a select Query to an update Query

M

maud0361

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
 
K

KARL DEWEY

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.
 
O

Ofer

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
 
Top