Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculating growth over a report grouping?
Thank you, Duane! That worked brilliantly!- sief
- Post #7
- Forum: Microsoft: Access Forms
-
Calculating growth over a report grouping?
The record source query has the following relevent fields: Contract: the top grouping, creating a summary for multiple contracts YearQuarter: The year and quarter SALES1: Sales field SALES2: Additional sales field ALLSLS: Sum of Sales1 + 2 REBATES: Rebates field YearOnly: Just the Year...- sief
- Post #5
- Forum: Microsoft: Access Forms
-
Calculating growth over a report grouping?
Thank you, that is a good start. The problem I experience now is that I am grouping on year so the expression isn't able to see the data for the previous years. Is there a way to allow the report to see that other data? Or is there a way to remove the year grouping and still have it go Q1, Q2...- sief
- Post #3
- Forum: Microsoft: Access Forms
-
Calculating growth over a report grouping?
Hi Everyone, I have a subreport that is a listing of quarters with the sales and rebates for each quarter. There is a total after each 4 quarters for the year totals. I want to be able to calculate the year over year growth... but I can't remember enough about Access reporting to figure it out...- sief
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
