strSQL = "SELECT [Drivers$].DriverID, MIN([CarList$].CarListDate), MAX([CarList$].CarListDate), [CarList$].CarId, [CarBrand$].CarBrandName " _
& "FROM ((([Drivers$]" _
& "inner JOIN [CarList$] ON [Drivers$].DriverID = [CarList$].DriverID)" _
& "inner JOIN [Cars$] ON [CarList$].CarId = [Cars$].CarId) left JOIN [CarBrand$] ON [Cars$].CarBrandId = [CarBrand$].CarBrandId) " _
& " Group BY [Drivers$].DriverID, [CarList$].CarId, [CarBrand$].CarBrandName "

SELECT CarMinDate.DriverID, CarMinDate.MinDate, CarMinDate.RegistrationNumber AS Номер_MinDate, CarMinDate.CarBrandName AS Марка_MinDate, CarMaxDate.MaxDate, CarMaxDate.RegistrationNumber AS Номер_MaxDate, CarMaxDate.CarBrandName AS Марка_MaxDate
FROM (Drivers INNER JOIN (SELECT MaxDate.DriverID, MaxDate.MaxDate, Cars.RegistrationNumber, CarBrend.CarBrandName
FROM (SELECT DriverID, Max(CarList.CarListDate) AS MaxDate
FROM CarList
GROUP BY CarList.DriverID) as MaxDate
INNER JOIN ((CarBrend INNER JOIN Cars ON CarBrend.[CarBrandId] = Cars.[CarBrandId]) INNER JOIN CarList ON Cars.[CarId] = CarList.[CarId]) ON (MaxDate.DriverID = CarList.DriverID) AND (MaxDate.MaxDate = CarList.CarListDate)) as CarMaxDate
ON Drivers.[DriverID] = CarMaxDate.[DriverID]) INNER JOIN (SELECT MinDate.DriverID, MinDate.MinDate, Cars.RegistrationNumber, CarBrend.CarBrandName
FROM (SELECT DriverID, Min(CarList.CarListDate) AS MinDate
FROM CarList
GROUP BY CarList.DriverID) as MinDate
INNER JOIN ((CarBrend INNER JOIN Cars ON CarBrend.[CarBrandId] = Cars.[CarBrandId]) INNER JOIN CarList ON Cars.[CarId] = CarList.[CarId]) ON (MinDate.DriverID = CarList.DriverID) AND (MinDate.MinDate = CarList.CarListDate)) as CarMinDate ON Drivers.[DriverID] = CarMinDate.[DriverID]