Bill-
It might be possible with an UPDATE query, but I would need to know the structure of the two tables and the field you want to "move".
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Feb 3, 2014, at 5:08 PM, Bill Singer <Bill.Singer@at-group.net> wrote:
I am attempting to correct some bad design in a table I created some years ago. I am adding new fields to another table and I want to transfer the information.
It would be great if I could drag down a Column on an Access query and copy the information and paste in the new table. That would be very easy. However Access only lets me copy and paste one field/record at a time. That takes a lot of time.
It there a way to move date into a new field in a current record on a current table.
I know how to use the append query to create new records but I do not know how to insert data into a current table, if that is even possible.
Thanks,
Bill
MN
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar