Copy an paste a column in a query

F

filo666

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?????
 
R

Rick Brandt

filo666 said:
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?????
Click to expand...

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