>I didn't see anyone suggest this yet.
>
>
>...
> order by 3
>
>
>For the ORDER BY clause you can use the column number. You can not use the column number in the GROUP BY clause.
This is what I had for a while but had to turn it with name reference because of problems it causes at the class definition and its expansion. For example, I have a property cField, for those lists you see here. If I switch two fields or change its order, I would have to think about change the ORDER BY 3 to another number for example. If I have ORDER BY FirstName, I wouldn't have to worry about it.
