help with ADO Sql statement

[TSur]

What is wrong with this code? It tells me missing operator error.
I want my results to be ordered by ProductCode and be between StartPlu and EndPlu...

rsOrderDetails.Open "SELECT * From OrderDetails ORDER BY ProductCode WHERE ProductCode >= " & StartPlu & " and ProductCode <= " & EndPlu & "", CN, , adLockOptimistic

[Sheppe]

Originally posted by TSur
What is wrong with this code? It tells me missing operator error.
I want my results to be ordered by ProductCode and be between StartPlu and EndPlu...

rsOrderDetails.Open "SELECT * From OrderDetails ORDER BY ProductCode WHERE ProductCode >= " & StartPlu & " and ProductCode <= " & EndPlu & "", CN, , adLockOptimistic

Order By is ALWAYS the last thing in an SQL statement. Put the WHERE clause before it.

[Mc Brain]

Try this:

rsOrderDetails.Open "SELECT * From OrderDetails WHERE ProductCode >= " & _
   StartPlu & " and ProductCode <= " & EndPlu & " ORDER BY ProductCode", _
   CN, , adLockOptimistic