Question: Where does Access store the table created when a query is run? 

Answer: The query returns results that may look like a *table* but in fact it's a temporary recordset that isn't *stored* anywhere.  You can export to MS Excel and save the results in an Excel file - but within Access, the query results aren't stored / saved anywhere.\n\nYou could change the query to a Make Table Query - and then the results would be placed in a table when the query is run.  To change the query from a select query (the default query type) to a make table query - open the query in design mode, select Query from the menu - and select Make Table Query.  Enter a table name (any name you decide - if it doesn't exist it'll be created).  Good luck.
This question from the Yahoo Q&A forum is categorized in the topic: Science & Mathematics