>Hi.
>
>Thanks for the code - I tried it with a few tweeks and it worked great.....
>
>until i tried to use a distinct select - then it wouldn't let me Seek! Are Seeks possible when you use a SELECT DISTINCT?
>
>Thanks
>
>Richard Owen
In order to use SEEK, you must have an index. You can create a single index tag on the result set of a SQL SELECT. To create more than one, you must make the result set read/write.