cumulative sums of the deviations

P

patrick

I need to use access to do the following: HOW???

I retrieve the values A and B from a table, then
calculate A-B, then I need to look at the previous
records' (A-B) value and add it to the current records'
(A-B), hence the current value of (A-B) is a cumulative
sum, i dont want a total, as i want the individual
records the the cumulative sum todate to be presented in
a query.

pat
 
Top