I have a table that contains data that is updated annually and keeps previous year data as well to reference - back 5 years.
So, to keep data in proper perspective, I created fields (as Current Year, Year-1, Year-2, Year-3, etc.) to store and reference data values.
I created a query to find...