Something in me just needs to express the disclaimer that I don't think this is the best way to manage your information. (*Whew* - now that that's off my chest...)
You would put a field in the intake table called "DateToMove" (or something like that) and place your date there.
You would then run an append query to add all records with "DateToMove" before or equal to today's date to the master table.
Because you want to keep the record in the intake table and not add it more than once, you would need to do either of the following:
1. Cross reference with the master table to add only records from the intake table that do not already exist in the master table
2. Add another field in the intake table (yes/no called "Moved") to indicate whether it has been moved to the master table. After running the append query, run an update query to mark the Moved field in all records where DateToMove is less or equal to today's date as true. (Your append query would then add records whose DateToMove is less than or equal to today's date AND where Moved is false)
The latter may work better for a number of reasons:
1. You will likely have primary key issues to compare the information in both tables.
2. To "hide" the record in the intake table, it would be easiest to have that "Moved" field. Then your intake form could retrieve all records in the intake table where Moved = false to "hide" those that have been moved.
[This message has been edited by shacket (edited 09-21-2001).]