How to save a Query as a Table?

A

A_Mayer

Assume I have a Table named "Friends". With a Query I extract all those who
live in the Negev. How do I save this "Negev" Query as Table
(not depended on "Friends" any more) ?

Akiva
 
K

KARL DEWEY

Change the query type to 'Make Table' by opening in design view and selecting
type.
 
J

Jeff Boyce

Why? As in "why do you feel you need a table?" Having a query that gives
you that information would allow you to use that query much the same way
you'd use a table, without the overhead of having another table...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jerry Whittle

I agree with Jeff. What happens when a friend moves and you only remember
change the address in one of the tables? Keeping all the similar data in one
table prevents this kind of data anomaly. One table - many queries.
 

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

How to save query output as a table?? 9
How / When to Create a Table from a Query 11
Programming a result field in a table 5
Adding records to a table 18
How to copy aQuery to a new Table? 3
my query does not update table 2
Save query results to another table 6
Table name as a parameter in a query 3

Top