Hi,
I have had the same problem. I can only do one query at a time. If i try more than one after the semicolon, i get an error message just like the one described earlier.

I am using the query tool to create my queries. Your solution appears like VB code. Can we use VB code inside the queries? Or are you saying that i need to create a program to run my queries.

My question is probably rather newbie, but i don't have much experience with MS Access.
Thanks.