7,712
社区成员
发帖
与我相关
我的任务
分享
要使用域函数或借助临时表,如:
update A AS T
set 记录数 = Dcount("*","B","字段名=" & T.字段名)
update bsc_temp2 set tch=
Dcount("*","bsc_temp","'" & bsc_temp2.site_no & "' =bsc_temp.site_no
and '" & bsc_temp2.cell_name & "'=bsc_temp.cell_name and '" & bsc_temp2.lac & "'=bsc_temp.lac and '" & bsc_temp2.ci & "'=bsc_temp.ci ")