以下是引用吹水佬在2021-6-20 16:44:45的发言：
是有点问题，这样呢
*可填报
SELECT 必修科数,必修科目 FROM 样表 WHERE (LENC(CHRTRANC(必修科目,", ",""))-LENC(CHRTRANC(必修科目,", 物生地","")))>=VAL(必修科数)
*不可填报
SELECT 必修科数,必修科目 FROM 样表 WHERE !(LENC(CHRTRANC(必修科目,", ",""))-LENC(CHRTRANC(必修科目,", 物生地","")))>=VAL(必修科数)
是有点问题，这样呢
*可填报
SELECT 必修科数,必修科目 FROM 样表 WHERE (LENC(CHRTRANC(必修科目,", ",""))-LENC(CHRTRANC(必修科目,", 物生地","")))>=VAL(必修科数)
*不可填报
SELECT 必修科数,必修科目 FROM 样表 WHERE !(LENC(CHRTRANC(必修科目,", ",""))-LENC(CHRTRANC(必修科目,", 物生地","")))>=VAL(必修科数)
谢谢，老师.
提取可报志愿.rar