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?
 
Back
Top