Bruce,
It maybe a limitation or a proper design. :) SQL Server indexes work the same way.
Why would you need such index if you don't have direct acces to a table anyway?
>
>Hi Sergey - that might explain why I haven't been able to find a way to do it in Access testing :-)
>
>What a limitation! I guess I might need to resort to SQL to get the proper sort into a new result table, in that case. Maybe still use some of the ideas we've been discussing, anyway...
>
>Thanks, Sergey (I think!) <g>
>
>You may have saved me a lot of Access struggling, anyway.
--sb--