Append Query help

[accessma]

I have a form that has a DELETE button on it. When it is pressed, the record is deleted which works fine.

Now I would like to APPEND the record to a table "Archived Records" before it is deleted. In addition, I would like to include when the record was deleted with a time stamp. The table name I am deleting from is called "Report".

Have searched the forum and can't find what I am looking for. Anyone have an idea how to do this?

 

[KeithG]

Just add your append query before you delete query. you can use the Now() function for the time stamp.

 

[accessma]

I could use an example. Im pretty new to this. Thanks