I want to create a recordset using one query, then do a subsequent query on the result to do some more manipulation. However, I can find no syntax for selecting from a recordset variable (what are its parent database and table names?). Sometimes I can use a workaround by having the first query be a SELECT...INTO, yielding a new table in a known database from which I can do the subsequent query. But when I want the first query to be a crosstab, it seems not to support SELECT...INTO. My current workaround is a routine I wrote to copy a recordset to a table but it is a *CLUNKY KLUDGE*! Surely there is a more elegant way. Any help?

TIA

Bob Alei