Hey Guys,

I have been searching the forum but have been unable to find any similar issues that I can use.

I have a table that has a yes/no field. If the box is checked for 'yes' i need that row to delete from the current table and be moved to an "archive" table.

What is the easiest way to do this? It would be so great if I could have the rows move when the associate closes out of the database.

I still have a lot to learn with Access so any sesame street explanation would be so helpful...

thanks guys

TallMAn :confused::confused::confused:

Generally most of us would suggest leaving the records in the same table and using the yes/no field to select records as needed (active, inactive, both). If there is some compelling reason to move them, you'd first execute an append query to copy them to the archive table, then a delete query to remove them from the original table. Both would have a criteria like:

...WHERE YesNoField = True