>>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.

i have also :p01>m01