edit table data with query

[Guest]

I am using a simple select query to edit table data in an MS SQL database. I
would like to be able to change all of the fields to be modified then have
them update the table as the process works now. Any suggestions?

 

[Guest]

Use an Update query. Backup your table if you are not familiar with Update
query.

 

[Guest]

Karl, that is a solution I have considered but the table is in a dynamic
process while I am making the change and I wanted to try something different
if possible. I have looked at the Help file and Knowledge Base and really
can't tell if it is possible to keep a query from updating a record
automatically. That is what I would really like to do - update the records I
see on the screen and not perform an update until I had what I wanted, then
click "Refresh records" or something like that to implement the changes.

 

[John Vinson]

Karl, that is a solution I have considered but the table is in a dynamic
process while I am making the change and I wanted to try something different
if possible. I have looked at the Help file and Knowledge Base and really
can't tell if it is possible to keep a query from updating a record
automatically. That is what I would really like to do - update the records I
see on the screen and not perform an update until I had what I wanted, then
click "Refresh records" or something like that to implement the changes.

Then your ONLY choice is to have a scratch table storing your changes.

A Query has no independent existance; it is NOT a separate set of
records, distinct from the table(s) which contitute the query. It's
just a way of viewing, selecting, and sorting the records in the
table. If you change the value in a Query, it IS the value in the
table that you're changing.

John W. Vinson[MVP]

 

[Guest]

What I do is to create a select query and use criteria for a narrow data set.
I review the data set manually and if all is ok I change it to an update
query and run.
I switch back to a select query and then change the criteria for the next
batch.

 

[Guest]

Thanks to both of you. I think this has me on a track that will do what I
need to do.

Stan