im using the append query to insert data into a table from another table, when the data is inserted into the new table, how can i populate the default value in a field in the new table?, ie when the record is inserted into the new table, i want to be able to capture the date and time of when this occurred.