Moving a column to another table

[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.

 

[Jeff Boyce]

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

 

[Guest]

We just need to move it permanently.
Thanks

Josh

 

[Jeff Boyce]

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

 

[Jamie Collins]

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.

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.

--

 

[Guest]

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

 

[Jeff Boyce]

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