我是用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.
arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(4) 人氣()