>I have a student.dbf with fields 1.Regno 2.Name 3.hscboard 4.maths 5.Physics 6.chemistry, the hscboard having three types Namely 1. 01 2.02 3.03. I have 500 records for hscboard(01) and 250 records for(02) and 100 records for (03).
>
>I want to change the three subject marks after normalisation for three hscboards. nomalisation for three hscboards given below
>
> for hscboard(01)
>
>maths =(maths*200)/100
>physics =(physics*200)/100
>chemistry =(chemistry*200)/100
>
See my suggestions inline
Update Student SET Maths = Maths * 2 , Physics = Physics * 2, Chemistry = Chemistry * 2 where hscBoard = '01'>for hscboard(02)
>
>maths =(maths*200)/300
> physics =(physics*200)/150
>chemistry =(chemistry*200)/150
>
Update Student SET Maths = (Maths * 200)/300 , Physics = (Physics * 200)/150, Chemistry = (Chemistry * 200)/150 where hscBoard = '02'>for hscboard(03)
>
>maths =(maths*200)/150
> physics =(physics*200)/150
>chemistry =(chemistry*200)/150
>
>I want to update these calculation values into my stduent.dbf for three hscboards.
>
>can anyone help me How to write progamme
Update Student SET Maths = (Maths * 200)/150 , Physics = (Physics * 200)/150, Chemistry = (Chemistry * 200)/150 where hscBoard = '03'
If it's not broken, fix it until it is.
My Blog