Help: Creating new table from existing

  • Thread starter Thread starter Steamy
  • Start date Start date
S

Steamy

I guess I cant see the forest through the trees. I would like to create
a new table from and existing table containing selected records with
selected fields. The selected records can come from a query or a
filter. Or. is there a better way?

Obviously this newbie needs some help.......

Thanks
 
You need to create a query with the fields and parameters
you want, then change the Query Type to a "Make Table"
query. Look for the ARROW DOWN key next to the large red
exclamation (RUN) button on the toolbar.
 
I guess I cant see the forest through the trees. I would like to create
a new table from and existing table containing selected records with
selected fields. The selected records can come from a query or a
filter. Or. is there a better way?

Obviously this newbie needs some help.......

Thanks
Click to expand...

The short answer is that you need to use the Query menu item to create
a "MakeTable" query.

The longer answer is... maybe you DON'T need to create a new table.
Storing data redundantly is A VERY BAD IDEA; there is occasionally a
need to run a MakeTable while creating the tables in the initial
design stages of a database, but routinely running make-table queries
during the *use* of a database is almost never a good thing to do.

Note that you can create a Query of selected fields and selected
records. This Query can be used as the recordsource for a Form or a
Report; you can export the data in the query to a text file or
spreadsheet; you can base another query on that query - almost
anything that you can do with a Table.
 
You need to create a query with the fields and parameters
you want, then change the Query Type to a "Make Table"
query. Look for the ARROW DOWN key next to the large red
exclamation (RUN) button on the toolbar.
Click to expand...
Thanks....that will work just fine. Bartender.....a drink for the man
in the corner.
 
Back
Top