text: where does access store the table created when a query is run?   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.  you 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.