I have built an sql string and it works fine if I paste it into the query designer.
But if I try
This brings up Run-time error '7874':Code:DoCmd.OpenQuery (sql)
Microsoft Office Access can't find the object .. and my query is shown as text.
Thanks for any solution.