AppendQueary

[AmyLynnHill]

I crated a DB that tracks new insurnace policies added to a system. Earch Week I run an append query that adds new records to a table. I want to be able to keep track of the new records each week. Does anyone know if there is a way to add a date field to the append queary? This would enable me to keep track of each weeks added records.

OR is there an easier way?

 

[reclusivemonkey]

Add a field to your table called DateAppended, then in your Append query add:

DateAppended: Now()

Now() will add the date and time. If you only need the date, use Date().