1. Post sample data that illustrates your problem  - as is, if we're familiar with your problem we can help answer but otherwise no. 2. Its highly likely there's a better approach, but we'd have to mock up data to test anything + write the code. Help us help you by at least providing the sample data. 3. When automating a process you need to generalize... Here's a quick attempt [Value(year)  /  Value(year-1) ] ^ [1 / # years of data in table] - 1) * 100 This tells me I'm always looking for previous years numbers and I also need the total number of years available. Now I can start writing a query to solve this.     It's usually easier to do this with a table of information though 😉   ... View more