strsql = "SELECT [Report$].[Регион],[Report$].[Канал], [Report$].[Город],[Report$].[Адрес], [Report$].[ФИО], [Report$].[Месяц],Count([Report$].[ФИО]) AS Повторы, [Report$].[С_] " & _
        "FROM [Report$] " & _
        "WHERE [Report$].[Год] is null " & _
        "GROUP BY [Report$].[Регион],[Report$].[Канал], [Report$].[Город],[Report$].[Адрес], [Report$].[ФИО], [Report$].[Месяц],[Report$].[С_Срок],[Report$].[С_] " & _
        "UNION " & _
        "SELECT [Report1$].[Регион], [Report1$].[Канал], [Report1$].[Город],[Report1$].[Адрес], [Report1$].[ФИО], [Report1$].[Месяц],[Report1$].[С_],Count([Report1$].[ФИО]) AS Повторы " & _
        "FROM [Report1$] " & _
        "WHERE [Report1$].[Срок]<90 and [Report1$].[Комментарий] is null " & _
        "GROUP BY [Report1$].[Регион], [Report1$].[Канал],[Report1$].[Город],[Report1$].[Адрес], [Report1$].[ФИО], [Report1$].[Месяц], [Report1$].[С_]"