I am having trouble visualizing an update query I wish to create. I have a table called teacher resources which contains data from multiple sets of years. As a new school year is approaching I want to “rollover” certain fields into the corresponding fields in the new year. Example:
From the school year 2014-2015 I want to copy the fields FTE and enrollment to the records for school year 2015-2016.
Can you get me started? Thanks!