hello everybody,
i have a sql query sql = _
"select Orders.ReceiptDate, Orders.OrderID," & _
"OrderDetails.OrderID, OrderDetails.ProdSumPrice " & _
"where Orders.OrderID=OrderDetails.OrderID and " & _
"Orders.ReceiptDate between #1/1/2007# " & _
"and #31/12/2007#"
Set rs = New ADODB.Recordset
rs.Open sql, conn, adOpenStatic, adLockOptimistic
When i am trying to open the sql query with rs ado recordset i am getting runtime error -214721700(80040e14)
which says that operator is missing in the expression 'OrderDetails.ProdSumPrice where Orders.OrderID=OrderDetails.OrderID and Orders.ReceiptDate between #1/1/2007# and #31/12/2007#'
I tried this query in microsoft access and it works fine.
I believe that the problem is in between #1/1/2007# and #31/12/2007# but i don't know what exactly could be maybe the character # but i also tried without # and i am still getting the same error. Any help will be much appreciated.
Thank you
all in advanced.
i have a sql query sql = _
"select Orders.ReceiptDate, Orders.OrderID," & _
"OrderDetails.OrderID, OrderDetails.ProdSumPrice " & _
"where Orders.OrderID=OrderDetails.OrderID and " & _
"Orders.ReceiptDate between #1/1/2007# " & _
"and #31/12/2007#"
Set rs = New ADODB.Recordset
rs.Open sql, conn, adOpenStatic, adLockOptimistic
When i am trying to open the sql query with rs ado recordset i am getting runtime error -214721700(80040e14)
which says that operator is missing in the expression 'OrderDetails.ProdSumPrice where Orders.OrderID=OrderDetails.OrderID and Orders.ReceiptDate between #1/1/2007# and #31/12/2007#'
I tried this query in microsoft access and it works fine.
I believe that the problem is in between #1/1/2007# and #31/12/2007# but i don't know what exactly could be maybe the character # but i also tried without # and i am still getting the same error. Any help will be much appreciated.
Thank you
all in advanced.