i'm using item numbers for the IN conditions to return a total of each item number ordered for sales orders between 2 dates. i need the results to be in the same order the item numbers appear in the IN statement. the item numbers in the IN statement are not sorted in any way.
is this possible?
if i use a date range i get a different order of results than if i use no date range and just the item numbers. but, neither is correct.