Dim sTemp As String sTemp = "SELECT COUNT(*) As ( " & champs & _ " FROM & EntreprisesA & ), " & _ " GROUP BY (" & champs & " ), " & _ " Having count(*)> 1)" Debug.Print sTemp Set rst = CurrentDb.OpenRecordset(sTemp, dbOpenSnapshot)
sTemp = "SELECT COUNT(*) As (" & champs & ") " & _ " FROM " & EntreprisesA & " " & _ " GROUP BY (" & champs & ") " & _ " Having count(*)> 1"
" FROM EntreprisesA " & _