update table from query

[5166narda]

I know this is easy but I can not think today - I have a report that is created from a query. I want to save the query data in a table to be accessed at a later time. How do I do this??? I can run the query but how do I assign the results to a table.....

 

[jrbarnett]

Turn the query into a Make Table, then enter the name of the table that you want to create.

John

 

[TheAceMan1]

5166narda . . . . .

Do you want to append or overwrite when saving the results?

TheAceMan

 

[5166narda]

append to an existing table

 

[jrbarnett]

in that case just change the first line to

insert into tablename (field1, field2, field3)
select < and all the rest of it >
from
where
blah blah

John

 

[5166narda]

do I have to do something special with the tablename - it is giving me an error - expected end of table..

 

[jrbarnett]

Exactly what is the SQL you have got at the moment?

&quot;Tablename&quot; is the name of the table that it will be added to, so must be the name of an existing table within your database.

John

 

[5166narda]

It is a valid tablename. Do I need to define the table as a recordset first? The query is a result of allot of tables and then I want to store the values in one specific table.