By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,722 Members | 1,350 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,722 IT Pros & Developers. It's quick & easy.

Calculate Median for a form

P: 36
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
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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.