D Denise Parish Apr 14, 2004 #1 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
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 Apr 14, 2004 #2 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?
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?
