How do I move a field from a table to a new table?

  • Thread starter Thread starter twells
  • Start date Start date
twells said:
How do I move a field (and all the associated records) to
a new table?
Click to expand...

It depends and I assume you want to move the column containing the
information rather than the whole record.
If the table has data in it then there must exist a relationship between the
old and new tables that would let you do an update query.
If there is no relationship or this is a new table then an append query
would be used.

You can also cut and paste the old table, giving it a new name.
 
Back
Top