Hey, i want to run a query that uses a DateTime criteria as follows:
But i get this error: "Data type mismatch in criteria expresssion"
Any ideas?
Code:
Dim SQL As String
Dim rs As Recordset
clientId = Me.CLIENT_ID
supplierId = Me.SUPPLIER_ID
dateIss = Me.AddedAt
SQL = "SELECT TRANSACTIONS.ID FROM TRANSACTIONS WHERE (TRANSACTIONS.TRANS_CAT = 1 OR 3 OR 4) AND TRANSACTIONS.CLIENT_ID= " & clientId & " AND TRANSACTIONS.SUPPLIER_ID= " & supplierId & " AND TRANSACTIONS.addedDate >= '" & dateIss & "'"
Set rs = CurrentDb.OpenRecordset(SQL)
But i get this error: "Data type mismatch in criteria expresssion"
Any ideas?