>>>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>m01po1 can be either greater than mo1 or less than mo1 (or equal mo1). So, by writing IIF expression I combine your two conditions.