Search results

Thanks for the response WayPay. I guess I didn't make my description of the requirement clear enough. What I want is a way so that the user can archive records based on a date range they enter into a form. The user then clicks the command button that runs the append query based on the date...

Okay, I've done the research and haven't found the answer yet. This is probably very easy but then I've only been working with Access for about a year. I have an Access 2003 database that has two primary tables with a parent-child relationship (1 to many) with "enforce referential integrity"...