You can't have the line avg = ((dailywork.nmen+dailywork.nwmn+dailywork.nadl)/(pkg.nripe+pkg.ngreen)) in the function because then you will always get the value from the same record! You must pass the approriate values to the function.



>Hi Tore,
>
>Thanks very much for your reply.
>
>I have entered the following code in a new method called 'getAvg' of my form:
>
>

>avg = ((dailywork.nmen+dailywork.nwmn+dailywork.nadl)/(pkg.nripe+pkg.ngreen))
>DO CASE
>	CASE avg >= 0 and avg < 20
>	 nColor = RGB(0,0,100)
>	CASE avg >= 20 and avg < 30
>	 nColor = RGB(100,0,100)
>	CASE avg >= 30 and avg < 40
>	 nColor = RGB(200,0,100)
>	CASE avg >= 40 and avg < 60
>	 nColor = RGB(0,100,100)
>	CASE avg >= 60
>	 nColor = RGB(0,200,100)
>ENDCASE
>
>RETURN ncolor
>

>
>And in the Init of the Grid...
>

>ogrd.SetAll("DynamicBackColor", "thisform.getAVG([Dailywork.nmen+Dailywork.nwmn],;
>[Pkg.nripe+pkg.ngreen])", "Column")
>

>
>Will you be able to help me as to where I've gone wrong?
>
>Regards,
>
>Steve