By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,807 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,807 IT Pros & Developers. It's quick & easy.

How calculate percent difference between fields in same group in a report

P: 5
Hi All,

I have a report sectioned/grouped by year with number fields (i,e attendance). I would like to calculate percent difference of attendance for each year.

Thanks in advance,
Cecil
Jun 12 '07 #1
Share this Question
Share on Google+
5 Replies


DeMan
100+
P: 1,806
Hi Cecil, could you please specify what technology/language you are using.
Jun 12 '07 #2

P: 5
Hi Cecil, could you please specify what technology/language you are using.

I'm using Access 2003...here is a little more detail...

I have a column report with summary information in the footer, in this case the year footer. In the footer, I have calculation to total the field for the year. (i.e."Sum([Persons Attending])' which sums total attendance in any given year). I would like to calculate the percent change in attendance form year to year.

I've tried building the report using crosstabs queries but run into a wall when a new year is added as i must alter the report for the most current year.
Jun 12 '07 #3

DeMan
100+
P: 1,806
Moving to Access Forum......
Jun 12 '07 #4

P: 5
Moving to Access Forum......
Hi DeMan,

sorry i didn't understand your last comment. Are we not in the Access forum, if not would you please direct me to the right location?

Thanks,

Cecil
Jun 12 '07 #5

DeMan
100+
P: 1,806
That's ok cecil, the thread has now been moved to the access forum (which ordinarily is available from the forums tab on the blue bar near the top of the screen).

The post highlighting the move was just to the experts (so if by chance I moved it to the wrong forum, they know to blame me not you).......

Hopefully the experts here will be able to assist!!
Jun 12 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.