>Thanks Sergey. I tried your query, but it still seems to bring up the running query box on screen and seems to take same amount (status bar indicates 1 record in 5.41 seconds) of time as the query I designed. I have my indexes in table, and I thought it might be the ORDER BY clause that may be causing slow query, but apparently not.
>
>thank you
>Nick Patel

Nick;

What happens if you Set Talk Off before your query?

Tom