OraFAQ Forum: Forms » to select best two from three quizez and the find its avaerage

Home » Developer & Programmer » Forms » to select best two from three quizez and the find its avaerage (orcle 8.1.7 and Developer 6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

to select best two from three quizez and the find its avaerage [message #346783]

Tue, 09 September 2008 12:54

orarep
Messages: 56
Registered: September 2007

Member

hi

i have tabular form and it contains four coloumns. i.q quiz1_marks,quiz2_marks,quiz3_marks and Total.

what i want is that student obrain marks in each quiz and then form automatically select best two quizez and then find it avaerage and put it in Total coloumns using any event like key-next-item etc.

i tried to use analytical function but i couldn't.

any can help plz, any idea

regards

orarep

Report message to a moderator