我是用Access來建Database
Start_Date = text1(0).text +1911 & "/" & text1(1).text & "/" & text1(2).text
End_Date = text1(3).text +1911 & "/" & text1(4).text & "/" & text1(5).text
Sql = "SELECT SUM(AMOUNT), ID from DATA Where DateValue(DATADATE) between '" & Start_Date & "' and '" & End_Date & "' GROUP BY ID"
不過只要是結束日期的月份在10, 11, 12.跑出來得結果就不正確, 請問各位高手幫我解答一下! Thanx.
Start_Date = text1(0).text +1911 & "/" & text1(1).text & "/" & text1(2).text
End_Date = text1(3).text +1911 & "/" & text1(4).text & "/" & text1(5).text
Sql = "SELECT SUM(AMOUNT), ID from DATA Where DateValue(DATADATE) between '" & Start_Date & "' and '" & End_Date & "' GROUP BY ID"
不過只要是結束日期的月份在10, 11, 12.跑出來得結果就不正確, 請問各位高手幫我解答一下! Thanx.
全站熱搜
留言列表