Hi everybody! I found a reason for loosing the "." in the SQL. When I turned off the "objectname autocorrect" (my access is in german, don't know the english translation) it still converts the subqueries, but the "." stays in place and the query works. :rolleyes: