469,625 Members | 1,127 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Calculate Median for a form

Has anybody got any ideas or nifty code for calculating the median value in a form.

I currently have a database which we use for post-course evaluations. Part of the evaluation asks the attendees for scores 1 to 10 on the course. Our education assistant inputs data from the evaluation forms into the database form. They manually add the number of 10's, number of 9's etc and input these values into fields on the form [Score 10], [Score 9] and so on.

What i need is a median score from 1 to 10 for that course based on the completed evaluations. This value is just for that completed form. I want this value to be calculated and displayed on the form and then stored in a field in the table.

Any help greatful.
Jul 5 '07 #1
1 1822
MMcCarthy
14,534 Expert Mod 8TB
There have been a number of previous questions on this issue. Check them out and come back with any questions.

http://www.thescripts.com/forum/thread655107.html
http://www.thescripts.com/forum/thread608740.html
http://www.thescripts.com/forum/thread640974.html
Jul 7 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Ross Contino | last post: by
2 posts views Thread by Hugo L. | last post: by
4 posts views Thread by uspensky | last post: by
3 posts views Thread by Scott | last post: by
3 posts views Thread by mehwishobaid | last post: by
6 posts views Thread by rrstudio2 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.