Hi, im having a problem working out a running totals formula. I have a subform running in datasheet view with a total column on it to total up the fee column in my table. i have used the dsum function to total up the fee's but it isnt running, its just the same total in each field (see attached pic). what i would like to do is a total upto the individual record (ie if the first record has a fee of 1 the first total is 1, second fee is 4 then second total is 5, etc) can anyone help?
as you can see, im just using the timer function to check the totals with dsum. iv'e left the criteria section of the function blank because i dont know how to set that to each record or even if i can using the dsum function. do you know of a better way of doing this?