Thx all! I wil bookmark this page in case the performance drops and I have to normalise the table. But momentarily the query works within 2 seconds.
The solution of Eberhard worked, with all in the same query. However, and that is also anoying in my other VBA issues, that the locale setting of...