Datestamp An Append Query Action

[BarryMK]

Access 97. I have a macro which appends a single record from my main table to an archive table and deletes the original record using append and delete queries. Is there any way I can datestamp the archive date on the archived record? I've searched this forum and can't find anything applicable.

 

[FoFa]

Just use NOW as the column
DTStamp: Now() in QBE

 

[Chasedog]

Add a date field to your archive table and in the append query add a column Datestamp: today(). When the query is run, it will add the current date to the table.

 

[BarryMK]

Sorry guys that's too easy I was looking for the hard way! Thanks for your help.