Senin, 08 April 2013

[MS_AccessPros] Please help: avg every 5 contiguous records...

 

Hi all.

I do not have any success to try to solve this problem...
I have a simple table containing 10 records. Each record contains a decimal value. I would like to average these values in a group of 10 contiguous records. For example:

Value
5
10
2
7
23 ----> 9,4
7
33
67
6
1 ----> 22,8

...so my query result will consist of 2 records like below:

Results
9,4
22,8

Any tip will be appreciated.

Many thanks
Ciro

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar