bm = Trim(Combo1.Text + Combo2.Text) 'bm是来查询access中的表名 rt.Open "update " + bm + " set 津贴 = chuqin.合计 from chuqin where chuqin.姓名 = " + bm + ".姓名", conn, 2, 2 报错为"操作符丢失,'chuqin.合计 from chuqin" 后来我分开写: sql= "update " + bm + " , chuqin set 津贴 = chuqin.合计 where chuqin.姓名 = " + bm + ".姓名" msgbox sql '打印sql语句 看看拼接字符串 是否正确 结果看到的是非常工整的 rt.Open sql , conn, 2, 2 还是报错为"操作符丢失,'chuqin.合计 from chuqin"昨天搞到凌晨3点,郁闷 

头晕啊，不知道