TrapData will always have the current years data. Once a year, I need to append the previous years data to TrapData. Then after reports are run for the current year, all records are deleted from TrapData (after the current year's data is saved to TrapData"year"). I can do this with an append query but since I won't be the user I would like to have a button that would automatically append the previous years data to TrapData.
I'm thinking you could create a module, to append the records, that would concatenate the name "TrapData" & System Year-1. This would then give you the changing table name from year to year. Hope this helps.