My answer was three words: Group by year. I meant that you can add those words to you queries. I'm sorry if I misunderstood your question.

>I went to foxite's website. and could not find your article... Can you give the download id?
>Searching for group by year, returns no results :(
>
>
>>To repeat what I wrote on Foxite: Group by year.
>>
>>>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