Is there away to make a new Table from a Query?
Yes - change it to a MakeTable query.
HOWEVER - it is *very* rarely either necessary or desirable to routinely
create new tables in your database. There is very little that you can do with
a Table which you cannot do - faster, more simply, and with less database
bloating - with a Select Query. If you want a Report - use a Query. If you
want to export data - use a Query. If you want to display data on a form - use
a Query.
Only if you want a *second, redundant* copy of the data, which can be edited
so that it no longer matches the data that it come from - and I admit,
sometimes you do want this - should you use a MakeTable.
John W. Vinson [MVP]
