Arthur, Thank you so much for your additional methods. It may take me a while to fully unpack and adapt your method, but I definitely love learning different approaches. I am using year as a string because I am using it as the vbar in a gchart. When I tried this with numerical year, it would create classes (2002.5 2007.5, etc), and I need things reported by instances per year. There may be another way, but I was handed this as a kind of last minute thing, so much of what I did was "brute force" and not particularly elegant, even by the standards of what little knowledge I have. I have completed the report, which used nearly 400,000 records split across 11 years and was reported differently on 27 pages, each with a gchart and a table that reported percentage growth of different variables per year. Now that it is done, I plan on exploring various method and seeing if I can tighten it up a bit. I've used macros in the past before, but due to the rushed nature of this, and how I (at least initially) felt that each page was different enough to make the macro not my best option. The lag function, of which I was not previously aware, made a huge difference - but I also like elegant solutions when I understand them. Thank you all again!
... View more