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?
