Why are you trying to move a field to another table? If you are in the midst of redesigning the database then it might make sense to do this, if however it is for display purposes remember that Access is not Excel, the way to get your items layed out how you want is not by re-organizing a table but by making a new select query.
