Thank you for your response.

The reason that I need a table is that I am using the data as a subquery.

Can I use a recordset as a subquery? I couldn't seem to figure out how to do that.

Okay, here's what I am trying to do. I have an some data that I need to be able to use as the IN clause of a different SELECT. The data gathered for the IN clause has to be generated procedurally, and cannot be done in a single select. I can put that data in a recordset, an array or a temp table. If I put it in a temp table, I can't delete the temp table. If I put it in an array or a recordset, I don't know how to use that as a subquery for the IN clause.

The recordset method would be a wonderful solution, but I can't figure out how to use it in a subquery.

Any ideas?

Thank you!