Here what I have

Five numbers inputed into their owner database feilds by the use of a form

Judge 1, Judge 2, Judge 3, Judge 4, Judge 5

I need the high and low remove and the remainder 3 numbers added up and it will be put in feild call Total (which is displayed in my form)

Then i am dividing this by 3 and putting it in a feild call score which is also display .

I have the table,forms created just need the VB code for the feild Total,

I already have VB code for score

I know this is simple but I am new and only doing this as a hobby

Thanks

Are you able to return a record with all 5 numbers to you app? If so are the numbers being stored as numbers or strings?

Yes the five number are inputed and display on the form and they are Standard numbers w/2 decimal place. they are store in the main table.

the total and score are also store in the main table after they are created.

I'm not getting the answers I need to help. Maybe the best thing for you to do is zip up your project (database and all) and post it.

ok here is a link of the project, right now it add all five score and divide by 5.

but rule want the high and low score drop and the remaining three score added and divided by3



http://sporttaekwondo.info/5judgeScoring-sm.zip



Thanks Randall