create table from query out put

[rony_78]

I have the following sql query in vb.net and ms access , how do I create a table from the query result ?

SELECT 'Table1' AS [Table], SUM(a) - SUM( AS Result FROM table1  

I have tried but it does not work

create table tble10 as SELECT 'Table1' AS [Table], SUM(a) - SUM( AS Result FROM table1 

any help would be appreciated

 

[justsomeguy]

Use SELECT..INTO:

 

http://technet.microsoft.com/en-us/library/ms188029.aspx