SELECT Predst.C_Data, Predst.C_Region, Predst.Predst
FROM Predst
WHERE (((Predst.C_Data)<(Date()- 34 )) AND ((Predst.C_Marka)= 5 ))
ORDER BY Predst.C_Data DESC;

z1:
Select Max(Date) as D, Reg
From tbl1
Group By Reg

SELECT Max(Predst.C_Data) AS [Max-C_Data], Predst.C_Region
FROM Predst
GROUP BY Predst.C_Region, Predst.C_Marka
HAVING (((Max(Predst.C_Data))<(Date()- 34 )) AND ((Predst.C_Marka)= 5 ))
ORDER BY Max(Predst.C_Data) DESC;

z1:
Select Max([Date]) as D, Reg
From tbl1
Where (Marka =  5 ) And ([Date] <= (Date()- 34 ))
Group By Reg

Select tbl1.*
From tbl1 Inner Join [ Select Max(tbl1.Date) as D, Reg
From tbl1
Where (Marka =  5 ) And ([Date] <= (Date()- 34 ))
Group By Reg ]. As z1
On (tbl1.Date = z1.D) And (tbl1.Reg = z1.Reg)