>>UPDATE res SET p01="Fail" WHERE p01<m01 >>UPDATE res SET p01="Pass" WHERE p01>m01 >> >>UPDATE res SET p02="Fail" WHERE p02<m02 >>UPDATE res SET p02="Pass" WHERE p02>m02 >>UPDATE res SET p03="Fail" WHERE p03<m03 >>UPDATE res SET p03="Pass" WHERE p03>m >>......up to 30 >>>
>Update res >SET po1 = IIF(po1<mo1, "Fail","Pass"), po2 = IIF(po2<mo2, "Fail", "Pass"), etc.Nomi:
i have also :p01>m01