Moving Records in Access 2000

D

Denise Parish

This is all very new to me. I would also like to know how to move records
from one table to another. Thank you.

Denise Parish
 
R

Rick Brandt

Denise Parish said:
This is all very new to me. I would also like to know how to move records
from one table to another. Thank you.
Click to expand...

There is no way to "move" per se. You use an append query to copy the data to
the second table followed by a delete query to remove it from the first.

Such activities would rarely be required in a properly designed database by the
way. What exactly is the reason for doing this?
 
Top