copying records from one table to another?

[owens2k]

does anybody know how i can use a query or command button to copy a record from one table to the next at a given date? if its only possible without the given date bit then thats fine!. thanx

 

[rockfish12]

Not exactly sure what you mean by "at a given date", but maybe this will help get you started...

http://www.accessfreak.net/KeywordSearchDetail.asp?page=13&order=id&recordkey=195