Access:楼主,是不是少了"&"呀! str = str & "维护时间>=#" & DTPicker1.Value & "# or 维护时间<=#" & DTPicker2.Value & "#"SQL Server Test: Private Sub Form_Load() Dim str As Stringstr = str & "维护时间>=#" & DTPicker1.Value & "# or 维护时间<=#" & DTPicker2.Value & "#" str = str & "维护时间 Between " & ConvertTimeToSQLServerSQL(DTPicker1.Value) & " And " & ConvertTimeToSQLServerSQL(DTPicker2.Value)Debug.Print DTPicker1.Value Debug.Print DTPicker2.Value End Sub '将时间转化成SQLServer认可的形式 Public Function ConvertTimeToSQLServerSQL(ByVal OriginalTime As Date) As String
str = str & "维护时间>= #" & dtp1 "# or 维护时间<= #" & dtp2 & "#"
SQL:
str = str & "维护时间>= '" & dtp1 "' or 维护时间<= '" & dtp2 & "'"多打几个空格没有坏处的。
少个&一定错
str = str & "维护时间 >= #" & dtp1 & "# or 维护时间 <= #" & dtp2 & "#"
SQL:
str = str & "维护时间 >= '" & dtp1 & "' or 维护时间 <= '" & dtp2 & "'"
str = str & "维护时间>=#" & DTPicker1.Value & "# or 维护时间<=#" & DTPicker2.Value & "#"SQL Server Test:
Private Sub Form_Load()
Dim str As Stringstr = str & "维护时间>=#" & DTPicker1.Value & "# or 维护时间<=#" & DTPicker2.Value & "#"
str = str & "维护时间 Between " & ConvertTimeToSQLServerSQL(DTPicker1.Value) & " And " & ConvertTimeToSQLServerSQL(DTPicker2.Value)Debug.Print DTPicker1.Value
Debug.Print DTPicker2.Value
End Sub
'将时间转化成SQLServer认可的形式
Public Function ConvertTimeToSQLServerSQL(ByVal OriginalTime As Date) As String
ConvertTimeToSQLServerSQL = "'" & Format(OriginalTime, "yyyy-mm-dd hh:nn:ss") & "'"
End Function
strTemp = strTemp & "维护时间 >= #" & dtp1 & "# or 维护时间 <= #" & dtp2 & "#"
SQL:
strTemp = strTemp & "维护时间 >= '" & dtp1 & "' or 维护时间 <= '" & dtp2 & "'"这回行了吧?