SELECT [1_Base].[1_id], [1_Base].[1_compani], Min([4_Mail].id_4_Mail) AS [Min-id_4_Mail], CLng([1_Base]![1_id] & [4_Mail]![id_4_Mail]) AS Выражение1
FROM (1_Base LEFT JOIN 3_Theme_Delivery ON [1_Base].[1_type] = [3_Theme_Delivery].category_recipient_3_Theme_Delivery) LEFT JOIN 4_Mail ON [3_Theme_Delivery].id_3_Theme_Delivery = [4_Mail].id_3_Theme_Delivery
GROUP BY [1_Base].[1_id], [1_Base].[1_compani], CLng([1_Base]![1_id] & [4_Mail]![id_4_Mail])
HAVING ((([1_Base].[1_id])=50612) AND ((CLng([1_Base]![1_id] & [4_Mail]![id_4_Mail])) Not In (SELECT CLng([5_History_Mail]![5_id_1]  & [5_History_Mail]![id_4_mail_5_theme]) AS id_number
FROM 2_cities INNER JOIN (1_Base LEFT JOIN 5_History_Mail ON [1_Base].[1_id] = [5_History_Mail].[5_id_1]) ON [2_cities].[2_id] = [1_Base].[1_id_cites]
GROUP BY CLng([5_History_Mail]![5_id_1] & [5_History_Mail]![3_Theme_Delivery_5_mail] & [5_History_Mail]![id_4_mail_5_theme]), [1_Base].[1_id], [2_cities].[2_id], [2_cities].[2_city], [1_Base].[1_compani], [5_History_Mail].[5_id_1], [5_History_Mail].[3_Theme_Delivery_5_mail], [5_History_Mail].id_4_mail_5_theme
HAVING ((([2_cities].[2_id])=349) AND ((Max([5_History_Mail].[5_date])>Date()-Day(7))=0));)));

SELECT Min(test.id_test) AS [Min-id_test]
FROM test
HAVING (((Min(test.id_test)) Not In (1)));

SELECT Min(test.id_test) AS [Min-id_test]
FROM [SELECT test.id_test
FROM test
GROUP BY test.id_test
HAVING (((test.id_test) Not In (1)))]. AS Min;