Investigate CREATE INDEX Note: (colname DESC) Colname is now always descending, no order by needed. RRR
MikeB wrote: > > RB 65 Win/Dos. If I want to do a select or chose on a dataset say based on > an Int or Date col in descending order Then limit the number of selections > with Limit = , the expected result would be the highest value Int or Date, > but this is not the result. The workaround is a Temp View, etc.
