Moving a column to another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a small issue. I have a database with two tables, Leases and Payment
History. In the Leases table I need to move a column "Payment Due Date" to
the Payment History table. I am not sure how to attempt this.
 
Joshua

One time (i.e., permanently), or are you trying to duplicate data in one
table in the other?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
One approach would be to add an (empty) column in Table2, then create an
update query to associate the values with their respective records in
Table1.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have a small issue. I have a database with two tables, Leases and Payment
History. In the Leases table I need to move a column "Payment Due Date" to
the Payment History table. I am not sure how to attempt this.
Click to expand...

Any reason why you have the word 'History' in your table name 'Payment
History' i.e. is there a distnction in your model between 'Payments'
and 'The history of each Payment'?

Jamie.

--
 
Being only marginally skilled in Access is there a reason why, in this case,
it couldn't be cut and pasted from one table to the other? I've done this a
few times with no obvious problems, but since it wasn't suggested I'm
wondering if I'm gettting myself into a unexpected potential problem when I
do this.

Messy
 
Since I don't have a clear picture of the data that already exists in the
respective tables, I'd point out that it might be possible to associate the
wrong values. I'd add a new column and either manually enter correct values
or use an update query to ensure the correct values.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top