Copying data to a new table

[munday63]

hi

I am trying to copy the data from one table into another table. I then wanted to update the table where it is copied from. This data i then wanted copied into that table in another row.

Any ideas?

 

[ColinEssex]

For the new table use a MakeTable query

For the updating use an Update query

Col