Query count previous record

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top