mkae table

[DD]

i would like to be able to write a make table query which should build 10
different tables. i have tried to do this all in one make table query but
it gives an error after the first make table query. the sql view ends the
first query with a ; after that the query doesnt function. is there a
different punctuation that will end the first make table and continue on to
the next. i dont want to create 10 different queries to do this.

thanks

 

[Van T. Dinh]

Query in Access can only contain one SQL statement / action, i.e. create one
Table, not 10.

If you want to create 10 Tables, use a (VBA) Sub that executes 10 SELECT ...
INTO ... statements.