CraigDolphin
GrumpyOldMan in Training
- Local time
- Today, 05:30
- Joined
- Dec 21, 2005
- Messages
- 1,582
Testing on a simple query and table confirms that it is the first field in the select statement, if it wasn't related to the Select statement you would be able to sort on non selected fields and not on calculated fields , and we have not begun to discuss multi table queries.
I wonder if your software is refering to an inherited Order By but I can only guess.
Brian
Ah...thanks for the correction Brian
