Moving records within Access 97

Hi

Try asking this question in the Office 2000 section - you are likely to receive a more appropriate answer there than here.

try an append query. see Access Help...

If you mean copy, then Sgt Schults answer is it. if you truly mean "move" where the record is no longer in the original table, then you must follow up with a delete query. you can create both the queries and then use the OpenQuery method in a macro to execute them. if you do not wish to get the warnings about adding and deleting data, use the setwarnings method to turn the warnings off.

Cut and paste works quite well for a limited number of records.

Otherwise, append and delete.