twells said:
How do I move a field (and all the associated records) to
a new table?
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.
