Home » Developer & Programmer » Forms » to select best two from three quizez and the find its avaerage (orcle 8.1.7 and Developer 6)
to select best two from three quizez and the find its avaerage [message #346783] Tue, 09 September 2008 12:54 Go to next message
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

Re: to select best two from three quizez and the find its avaerage [message #346822 is a reply to message #346783] Tue, 09 September 2008 15:51 Go to previous message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Search the OraFAQ site (not only the Forum) for the "top n" queries (as you need "top 2 marks").

Report message to a moderator

Previous Topic: Icons are not showing on client pc in forms 10g application
Next Topic: Message "Do you want to save change you have made?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 12 18:54:46 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.