I left the CTE in the old ODBC format, since it worked that way. But I changed another recordset to the SQLOLEDB provider that did the inserting and that speed things up considerably... which provided access to the winning solution. Muchos... Rob Smith LexJet rob.smith at lexjet.com http://www.lexjet.com (800)453-9538 (941)330-1210 Int'l (941)330-1220 Fax 1680 Fruitville Road, 3rd Floor Sarasota, FL 34236