There is a better and simpler way to do what you desire.
Add criteria to your queries of [Completed Date] Is Null for all
using currrent data.

If you need an annual report all projects, open and completed are in the
same table to provide yearly totals.

If you insist on doing it your way then in a macro named Autoexec have 2
actions. The first to append from current records to archive table all that
have a date in the [Completed Date] field. The second action to delete all
current records that have a date in the [Completed Date] field.

--
Build a little, test a little.


"Grasavong" wrote:

Hello,
I have a question that I'm not sure if it's possible for Access 2003. I'm
creating a database where we would like to use a project's end-date as the
trigger for archiving the record (row) to an 'archived' or 'completed' table.

For example: Suppose Project #10 was finished on 10/10/09. Once someone
enters that field (which is called 'Completed Date') with a date, the record
is automatically removed from the current table and sent to an 'archived' or
'completed' table.

I was wondering if this is possible instead of having to manually cutting
each row that has a finished project to the completed table.