If you are creating temporary records in this Paradox table just to do such
queries, then do not use Paradox, create the temporary tables in SQL Server.
Then SQL Server itself can execute the entire query for you directly and it
will be *fast*. You can still use the BDE, but will no longer have to depend
on the BDE *performing* the query for you, but only returning the results
from SQL Server.
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
"Nature abhors the vacuum tube." - J.R. Pierce, Bell Labs engineer who
coined the term 'transistor'