I need to automate an Access database. I have data in 1 hour interval. This data should be stored for 3 days. After that, the data should be automatically updated to daily intervals. Can I do that using an Access module or in VB code.

Any ideas,

please