I'm not sure if I can do this in Access or not, but what I have are 2 tables in Access, Ongoing and Closed. I have a lot of columns in each table, the two that are specific to this are Date Opened and Date Closed.
What I want is if I enter a date in the Ongoing table in column Date Closed, that it moves the whole row of information to the Closed table.
Is that possible? Thank you for your help!