>I have a table that stores data for years.
>
>I know how to query the data to get totals, averages, etc for individual years. I even understand how to query for specific months in each years.
>
>I am wondering what is the best way to compare data year to year? ie look for trends.
>
>I mean like 1999, 2000, give the totals, averages etc, so I can see the net change from year to year. (I know how to convert it to a percent.)
>
>What I need is some helpful ideas.
>
>TIA,
>Mike
Not sure if I understand you correctly, but to the question "what is the best way to compare data year by year" I would answer that "an image is worth a thousand words", so I will use FoxCharts to create a graphical representation of your data.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges