Archiving access database records

Hope this helps:

1. know when you want to archive your data. say per month
2). Date will be so virtual in archiving, inserting and retrieving data
3). Create a form where data of past months can be accessed from, that is if ur data is being archive on monthly basis

Assuming u want to view that from ur access database select where month = month.today. this makes it impossible to view data of past months thus data from past months can only be accessed via the archive form.