这句SQL语句为什么不行?
SQL="Select sum(货量) From tb_dhtj Where 抵港日>#" & date1 & "# AND 抵港日<#" & date2 & "# Order By "&dl&""
'SQL="Select * From tb_dhtj Where 抵港日>#" & date1 & "# AND 抵港日<#" & date2 & "# Order By "&dl&""
'SQL="Select Count(货量) From tb_dhtj Where 抵港日>#" & date1 & "# AND 抵港日<#" & date2 & "# Order By "&dl&""