Sinppage
>
>Just my .02 (US) here. I'd opt for names. I think it's more flexible. Using the field number ties query to the order of the field within the table. If the structure changes, say a new field is inserted, then this would have to change too. Using the name doesn't have this problem.

George,

While I always prefer names too, I have had many cases where the field number was the only way to get an ORDER BY to work!

Cheers,

Jim N