I have created a form that allows the user to select a client then displays related information via several tagged sheets each of which has subforms. One of the subforms looks something like the following:
Category Jan Feb Mar Apr .......Dec TOTAL
A 100 150 120 100 130 2700
B 50 45 70 90 70 1200
CUM-SUB 150 345 535 725 3900
The CUM-SUB row as well as the TOTAL column are calculated fields
I would now like to create a graph in another subform that displays the CUM-SUB data by month - in other words the X-Axis needs to be the months. I have tried to create the graph but have come up against a couple of problems that I don't know how to tackle and seek your help (I am an Access novice).
1. How do I refer to calculated fields from one sub-form in another sub-form?
2. How do I get the graph to display all 12 months (when I used the wizard it said I could only use 6 variables)