I have a database that has about 20 reports and 30 queries. The database tracks teachers budgets and how much they spend. We enter all the items that the teachers have bought in the database. It works great for this year but what about next school year. How do I set it up so that I do not have to delete all the records of transactions that teachers have made over the current year? I pull budgets for teachers off one table that feeds all the rest of the queries and reports. Each year the budgets change for all the teachers. So how do I set it up so that i can use next years school year and I can change the staff table with budgets without changing the current years totals and reports. I will need to do this year after year. I do know that I can duplicate the database and take out the transactions that they teachers have made and change budgets and have a fresh database. But I want to be able to compare the years and months with each other in one database. So next year I want to look at March and see what we spent during the 17-18 school year and compare it with 16-17 school year. i hops this makes sense. Any help would be great.