CLOSE DATABASES
SET SAFETY OFF
USE bb IN 0
USE aa IN 0
SELECT aa
COUNT TO x总人数
COUNT for subs(ksh,9,2)="11" to x专升本
COUNT for subs(ksh,9,2)="14" to x高起本
COUNT for subs(ksh,9,2)="15" to x高起专
COUNT for subs(ksh,9,1)="7" to x非统考生
COUNT for kstzbz="34" to x二学历
COUNT for kstzbz="31" or kstzbz="32" to x免试生
COUNT for kstzbz="35" to x资格生
SELECT bb
IF RECCOUNT()>0
ZAP
ENDIF
APPEND BLANK
REPLACE 专升本 WITH TRANSFORM(x专升本),高起本 WITH TRANSFORM(x高起本),高起专 WITH TRANSFORM(x高起专),统考生 WITH TRANSFORM(x专升本+x高起本+x高起专),;
二学历 WITH TRANSFORM(x二学历),免试生 WITH TRANSFORM(x免试生),资格生 WITH TRANSFORM(x资格生),非统考生 WITH TRANSFORM(x非统考生),;
总人数 WITH TRANSFORM(x总人数)
BROWSE