Make a table from a Query?

  • Thread starter Thread starter Guest
  • Start date Start date
Yes it is, you can select Query and then change the query to a make table
query.
 
Is there away to make a new Table from a Query?
Click to expand...

Yes - change it to a MakeTable query.

HOWEVER - it is *very* rarely either necessary or desirable to routinely
create new tables in your database. There is very little that you can do with
a Table which you cannot do - faster, more simply, and with less database
bloating - with a Select Query. If you want a Report - use a Query. If you
want to export data - use a Query. If you want to display data on a form - use
a Query.

Only if you want a *second, redundant* copy of the data, which can be edited
so that it no longer matches the data that it come from - and I admit,
sometimes you do want this - should you use a MakeTable.

John W. Vinson [MVP]
 
You must log in or register to reply here.

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

Make table query: [Enter 1] AS Test 1
Delete Query: Could not delete from specified tables 0
Make-table query with around 2 ml records taking too long 0
update query vs make query 5
Dynamic Access Table from Form 0
make-table 1
Daily Make Table Query 1
Make Table query 2

Back
Top