A1VBCode Forums

Simple Math coding in Acces 2003


http://www.a1vbcode.com/vbforums/Topic27904.aspx

By RCBNewbee - 7/8/2009

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

By RCBNewbee - 7/11/2009

Ok here a simple version of what i need can anybody help?
 
Each record has 5 numbers inputed into their own database fields by the use of a form (to a table)

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

I need the high number and low number seperated and put into a their own field
with high go in field high and low go in field low.

Then i be using these fields for other function which i already figure out.

can anybody help me. VB code or something

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