creating a table from a query

[Guest]

Once you have your query built, you can change it to a
make-table query.

-----Original Message-----
I would like to create a table based on a query so that I

can add more detailed information to only the records
found in the query.

 

[Guest]

Open your query in design view. Then, you can either
press your right mouse button, or select the query type
button on the top tool bar. Select make table query. It
will ask you for a table name.

The contents of the table you make won't automatically
update when the original table changes, but you can always
re-run the make table query. It will delete the table
that was created from the last time the query ran, and
create the table again, with the updated data.

-----Original Message-----
How do I do that and will it update when the information

in the original table the query is based on changes?