On Mon, 15 Mar 2010 17:54:01 -0700, Jenni
wrote:

I need to create a database that lists companies, with dates items done by,
money paid, notes etc. Thats okay, but I need to retain the previous years
records and start a new year off fresh. How would I do that?

Store all the data in one table, with a date/time field. "Start the new year
fresh" by basing your Forms (and where necessary reports) on Queries selecting
the desired date range.

Having separate tables for each year makes sense for a spreadsheet but no
sense at all for a database!
--

John W. Vinson [MVP]