OK ladies and gentlepeople, this should be an easy one.

How do you reference a result set generated by MS-Jet SQL's SELECT statement? I know you can do INTO tablename. But I don't want to create a new table.

And, can't you just type it (Jet SQL) in a code module or event procedure? I've done it in queries.

TIA