Calculations in Group footer

[Cecil]

Hi,

I have a report based on a query. In the query i have several fields (year,
attendance, occasions, paper sales). Note i did not group query to derive
totals as i permored this task in the report's Year foorter.
I.E....sum([Attendance]), sum(Occasions]), etc. I would like to calculate the
percent change in each field for every year there is data. For example if
Attendance in 2003 is 20 and Attendance in year 2004 is 25 this field
calculate the percent change from 2003 to 2004, 25%. Is this even possible,
it seems so?

thanks in advance,

Cecil