Ggrouping and do calculation on number of records (1 Viewer)

[anzacks]

Hi all,

I tried to make a query that can do calculation (sum/count/avg/etc) on certain number of consecutive record.
e.g.

Time; Value
1; 5
2; 3
3; 4
5; 2
7; 5
11; 8
20; 5
22; 3
25; 1

Let say i want to sum each 3 consecutive records
Time group; Sum
A; 12
B; 15
C; 9

Any function can be use for this?

Thanks.

 

[MStef]

Look at "DemoGroupEach3A2000.mdb"
Look at tables, queries, Form1, Module1.
Open Form1 and try.