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.

Signature
HTH
Van T. Dinh
MVP (Access)
>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
[quoted text clipped - 4 lines]
>
> thanks