Hi,
I have been scrambling around for solutions to the problem you mention below. I saw you post, but no replies, did you find an answer?
Cecil...
cecil
Last Activity: Feb 5 '08, 03:57 PM
Joined: Jun 12 '07
Location:
-
Calculating the difference between two records in the same field
I have filed titled "Sales". My report list the following records:
Year Sales
2002 1,000
2003 5.000
2004 6,000
2005 7,000
I would like to calculate the percent changes of sales from year to year
Cecil -
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...Leave a comment:
-
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...Leave a comment:
-
How calculate percent difference between fields in same group in a report
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
No activity results to display
Leave a comment: