I need to export results from a real time table into a csv file then copy the results in the real time table and place them into an archive table then delete from the real time table.

I need to keep adding to the archive table so the entries need to start from the last record.

Im pretty new to access and im still learning! Hope someone can help????


Thanks.

You could use an Append Query to add the required records to the Archive table and you could use a Delete Query to delete the records from the Real Time table. See access Help for more info.

You can always run a query from code behind a button.