Query count previous record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,

Can someone help me with the follow problem.
I want to count in acces in an query the first record then in the second row
i want to count the first and the second record. In the thirth i want to
count the thirth and the sum of the second record.
Is someone who can help me with this problem

kind regards
Rogier
 
Karl,
This is an example the month runtime quantity and % month is from a table,
and the count is the function i don't now how to make. The first row is 233
but the second row is the first row + the second row (233+75), i have wrote
the count he must make.

Month Runtime Quantity % month Count
10 1 233 66,38% 233
10 2 75 21,37% 233+75
10 3 26 7,41% 26+75+233
10 4 11 3,13% 11+26+75+233
10 5 2 0,57% 2+11+26+75+233
10 6 1 0,28% 1+2+11+26+75+233
10 7 1 0,28% 1+1+2+11+26+75+233
10 9 1 0,28% 1+1+1+2+11+26+75+233
10 10 1 0,28% 1+1+1+1+2+11+26+75+233

I hope you can help me with this,
best regards
Rogier
 
Back
Top