Endless query
Hi i populate a dataset (VBA) to insert data in a local table for statistics purpose. To detail the problem, i make dynamically a request to access different group by or kind of data according to informations in a form. All was working fine with multiple query on the stats table until i generate this simple query => SELECT sum(nb_connex) AS Cumul FROM Stats WHERE format([jour],"yyyy-mm-jj") < "2020-01-01" and [code_dossier] in (select distinct code_dossier from stats) GROUP BY [jour], [code_dossier]; The query never ends in the vba, even in query mode. The stats table is a linked one. If i use other parameters in the "in" clause or If i try this query in MySQL Workbench,the result is immediate.