How to save a Query as a Table?

  • Thread starter Thread starter A_Mayer
  • Start date Start date
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
 
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
 
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.
 
Back
Top