有没有加载符合条件的数据?
msgbox("
[发货日期]>= #" & dt0 & "# and [发货日期]<= #" & dt3 & "# " & qth & "And substring([ddlb],1,1)='c '" & " And 发货日期 Is Not null")
msgbox("[发货日期]>= #" & dt0 & "# and [发货日期]<= #" & dt3 & "# and [客户] Not In ('abb','魏德曼','博瑞','博驰','望变') And substring([ddlb],1,1)='c '" & " And 发货日期 Is Not null")
把上面条件附加到下面sql后面,然后到数据库里查询有没有结果?
select Sum(自产重量) from ddpsb where