copying recordset to net table

J

JMorrell

From a user defined function on my SQL server, I have a recordset returned to
my Access app. From that recordset, I want to make a temporary table that I
can use in several forms and several queries. I intend on dropping the table
after user logs off or at a later time in the day.

Can someone give me the syntax to create this table on the fly?

tia,
 
Top