Replace values - simple question 1

[bergis]

Hi, If I change values in a column in a query with selected records, will the values in the table also change for these records(and yes, I want it to)
tia
regards
Kjell

 

[pflangan]

yes. why don't you try it.

there may be an instance where the query is based on two or more tables where you cannot update, ie the query is read-only

 

[tlbroadbent]

Sorry, the answer is NO! :-(

A SELECT query selects records. An UPDATE query will be required to change or update the data. You can update multiple columns and multiple rows in one query. You can do conversions, arithmetic operations, and other manipulations in the update query.

UPDATE tbl SET col1=99, col2="abc", col3=col3+5, col4=date()
WHERE colA=22 Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln

 

[pflangan]

Well I'm sorry too tlbroadbent, but if you create a SELECT query in Microsoft access, then there is an instance where
you can modify the underlying data.

Query
------
SELECT Field1, Field2, Field3 FROM Table1

open the datasheet view of the query and modify it!

what about forms? What happens when you set the control source of a form to be a SELECT query?

Can you add records to the underlying table?
I think so.

|-I

 

[tlbroadbent]

pflangan,

No argument. You are correct. I interpreted the original question differently than you did. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln

 

[pflangan]

muchos gracias tlbroadbent.

Reflecting, I see that the dates are the same, and that possibly you were saying no to the original question, and not my answer.

paul.