At my school, the kids earn money each week, fake money that they use to apply towards school supplies and towards end-of-trimester field trips like skating or bowling.
I haven't figured out a way to create a line graph. I'd like the X axis to be each week, and the y axis be their cumulative earnings for the trimester. If a kid earns $8 the first week and $10 the second week, how could i create a line graph that shows $8 and then $18 (week 1 + week2)? There seems to be a way; I just can't find it.
PS. Each advisor deposits the amount into the database. Each week its deposited, a week number is calculated. Entering the deposit on 9/24 would give us a school week of 6. So the students right now have 6 deposits in the system and each is marked by a week: Week 1, 2, 3, and so on.
That keeps each week separate allowing me to do things with the data.
Have you tried using a running total summary field?
BTW, can you be sure that each child earns money every week?