Make the query a Make Table query type.
Use caution with this technique. If you plan to repeat
the process with the same query, the previously-made table
will be deleted and replaced with the next run of the
query. Sometimes this is what you want, and sometimes
not. If you want to create a table in an initial run, and
later 'append' new records to the made table, you need to
use an Append query type in the subsequent runs, which
will add to the table but not delete it.
Hope this helps
