469,894 Members | 2,209 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,894 developers. It's quick & easy.

Averaging Data Rows in Access



I am trying to develop a simple and efficient to calculate averages. For
example I want to calculate the averages of the Values for rows 1 and 2
and use ID 1 as the row with the average result.

Table Exmple
ID Value1 Value2 Value3
1 2 3 1
2 5 4 32
3 4 45 6
4 12 78 12

I can set up the Function to call the recordset, but I"m at a loss. It's
been over two years since I've had to write code. Any help would be
greatly appreciated.

THanks,J.


*** Sent via Developersdex http://www.developersdex.com ***
Dec 5 '07 #1
1 1798
On Dec 5, 11:35 am, JJ R <jjrobinson...@hotmail.comwrote:
I am trying to develop a simple and efficient to calculate averages. For
example I want to calculate the averages of the Values for rows 1 and 2
and use ID 1 as the row with the average result.

Table Exmple
ID Value1 Value2 Value3
1 2 3 1
2 5 4 32
3 4 45 6
4 12 78 12

I can set up the Function to call the recordset, but I"m at a loss. It's
been over two years since I've had to write code. Any help would be
greatly appreciated.

THanks,J.

*** Sent via Developersdexhttp://www.developersdex.com***
Not sure waht exactly you want averaged. In averaging
'rows' (records) 1 and 2 do you want the result to be...
a) 3.5, 3.5,16.5 (the average of 2 and 5, the average of 3 and 4, the
average of 1 and 32)
b) 2, 17 (the average of 2, 3, and 1 :: the average of 5, 4, and 32)
c) 7.8333333 (the average of 2, 3, 1, 5, 4, and 32)

Dec 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Rotten Spice | last post: by
4 posts views Thread by Matt Hamilton | last post: by
4 posts views Thread by George | last post: by
9 posts views Thread by Anil Gupte | last post: by
1 post views Thread by Kid Programmer | last post: by
bergy
2 posts views Thread by bergy | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.