Appending a table

[Guest]

I have 3 tables one has cutomer info. the other has the related orders for
that customer and the 3rd is old customer/order info.
What I need to do is move the data from the order table to the old
customer/order info table when I remove a customer from the customer table if
they have not placed an order in more than 2 years.

 

[Guest]

Hi Michelle,

Why not just mark the customer record as inactive, and then include a
criteria on this field in a query that serves as the form's recordsource?
That way, you may not need to move records.

Archive: Move Records to Another Table
http://allenbrowne.com/ser-37.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________