Hi,
I have a column in my access database table and I want to add another column with average of every 20 numbers, like that:
Field1 field2
a1 null
a2 null
..............
a20 (a1+....+a20)/20
a21 (a2+ ...+a21)/20
a22 (a3+.....+a22)/20
.............................
an (a(n-20)+...+a
)/20
Can enybody help me, please?
Regards,
ulm
I have a column in my access database table and I want to add another column with average of every 20 numbers, like that:
Field1 field2
a1 null
a2 null
..............
a20 (a1+....+a20)/20
a21 (a2+ ...+a21)/20
a22 (a3+.....+a22)/20
.............................
an (a(n-20)+...+a
)/20Can enybody help me, please?
Regards,
ulm
