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