Copy an paste a column in a query

[Guest]

Hi, How could I automatically copy a column in a query and paste it replacing
the information of another column of the query, preferible with a button
pasted in a form?????

 

[Rick Brandt]

Hi, How could I automatically copy a column in a query and paste it
replacing the information of another column of the query, preferible
with a button pasted in a form?????

We don't copy and paste in databases. You need to use an update query and
you would do this against the source table that your current query is based
on, not on the query itslef although you might need to copy the same WHERE
clause that your current query is using.