SQL日期為篩選條件的問題

lichangjun2012 · 发表于 2013-8-10 14:35

Sql = "select a.BP-I,a.BP-O,b.SP-I,b.SP-O from ((select sum(S13) as BP-I , sum(S17) as BP-O from ([list$A4:CM65536] where s11= #" & Range("c4").Value & "#) a "
sq = sql & "UNION (select sum(S27) as SP-I , sum(S31) as SP-O from [list$A4:CM65536] where s25= #" & Range("c4").Value & "#) b) "

ashleyfeng · 发表于 2013-8-12 09:59

提示: JION的運算錯誤

		自动登录	找回密码
密码			免费注册

[求助] SQL日期為篩選條件的問題