sql="select sum(cdbl(zfkuan) as zgd from zhi_rui_e_Word where cid="&fk&""cdbl就是将文本转数字的,如果你里边是整数,可以把cdbl换成int,这样就能sum了