问题:DLOOUP语句单引号的问题?
sSql = "UPDATE [ " & List1 & "] AS T1 SET T1.Assign = DLookup(HBID, [Zsys_tblCK_GL_BANK], GL= ' " & T1.Assign & " ') "
sSql = sSql & "WHERE (((LEFT(T1.Assign,4))= '0111 ')); "
DoCmd.RunSQL sSql
运行的是提示 错误 424 需求对象
提问时间:
2007-3-29 3:04:40 回答次数:
(8) 提问人:
软界网友 我来回答