Storing Data in Temp Table

[jboyle]

Is there a way to store data in a temp file? I want a query to filter records based on the data in the temp table.
Thanks in Advance - John

 

[neileg]

There's no difference between a temporary table and a permanent one in terms of Access. It's the way you handle it that is different. Therefore if you create a temporary table you can base a query on it.

It would normally be easier to make the table permanent so that you don't have to recreate the relationships all the time, and make the data the temporary part.