When sending a SQL statement to an Access database to retrieve certain records (in this case, information on products including the description and price), I want Access to return the results in the order of which I send my request... Example, my SQL statement reads:
SELECT PROD_NO,PROD_DESC,PRICE_W FROM PRODS WHERE PROD_NO IN ("9455,3215,5666")
I want it to return 9455 first, 3215 second, and 5666 last. However, for some reason, it organizes it by the PROD_NO. So it returns 3215,5666,9455. This may actually be a problem with ADO organizing the data, but I'm not sure. Haven't been able to find anything on it for either ADO or Access. Please help me figure this one out! Thanks all!
p.s. I do have a valid reason for wanting to do this, believe it or not. =)