can I create a new table by running a query

  • Thread starter Thread starter L. T. Portella
  • Start date Start date
L

L. T. Portella

Is it possible to run a query on a VeryBigTable that will select some
specific records and then with the results create a SmallTable. thank you
 
build the query to select the records you need. then, in the design view
menu bar, click Query, Make-Table...
enter a name for the new table, click OK, then click the Run button on the
toolbar (!).

hth
 
You can use a MakeTable query to create a table from what a query
selects/returns.

But are you sure you want to have two copies of the same data (everything in
the SmallTable will also be in the VeryBigTable, right?)?

You haven't described your underlying need, just a technique you want to
use. Is there a chance you could just create your select query and use
THAT, instead of a new table?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Returning Multiple Results 1
Combine Duplicates in Query 0
Parameter Query Won't Run 0
Parameter Query No Results - Needs to Auto Create Record 4
Make-table query with around 2 ml records taking too long 0
Query to Form View 1
Make table query: [Enter 1] AS Test 1
Remove a result from a query 2

Back
Top