You can create an INSERT INTO query based on the query you've created.

You'd create it the same as any other Make Table query, except you'd base it
on your query, not a table.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"BobC" wrote in message
...
Using MA 2007 ...
I would like to create a new table from the output of a query.
Can this be done ... if so how?
Thanks
Bob