Wierd grouping by month problem.

[capdownlondon]

I have a form that has a running sum on it of a value. each value has a date attached to it. so for example

Childs name 1

week start points total points
-relevant values for that child-

Childs name 2

week start points total points

etc etc etc......

so anyhow it appeared to be working fine for what i wanted it to do, until i reach another month, and then it resets and appears like this:

Childs name 1

week start points total points
-displays all relevant data for first month, in this case march.

Childs name 1

week start points total points
-displays all relevant data for april starting the sum on total points from scratch.



This is causing me big problems, i dont know why its resetting each month. How can i stop this happening? I just want a continuous sum for each childs details. And none of the data is sorted like this in any query or table, it must be the report that is creating this problem.

thanks

Adam

 

[Dennisk]

a running sum is a property of a text box control on a report only.

using a SUM function in a form will only sum the current recordset for that form.

 

[capdownlondon]

ok, well stupidly enought it is a report not a form, sorry my bad. but i sorted it kind of anyway. i worked out it was the grouping on the report, but it had the date grouped by month, so i changed it, to by each yeare, which kinda solves the problem for up2 a year, at which point it shouldnt be a problem.