Упростить sql запрос

[igor00082]

strSQL = "SELECT Пользователи.Телефон1, Пользователи.UserID, DMax(""[Дата публикации]"",""[Объявления] архив"",""[UserID]='"" & [UserID] & " "' и [Область]='" & Me.Комбинированная105 & "'"") AS Дата, DLookUp(""[ID]"",""[Объявления архива]"",""[UserID]='"" & [UserID] & ""' и [Дата публикации]="" & Format([Дата],""\#mm\/dd\/yyyy hh\:nn\:ss\#"") & "" и [Область]='" & Me.Комбинированная105 & "'"") AS ID, DLookUp(""[Год выпуска]"",""[Объявления архива]"",""[UserID]='"" &[UserID] & ""' и [Дата публикации]="" & Format([Дата],""\#mm\/dd\/yyyy hh\:nn\:ss\#"") & ""and [ Область]='" & Me.Комбинированная105 & "'"") AS Год" & _ 
" ОТ Пользователи" & _
" WHERE (((Пользователи.Телефон1) Is Null) And ((DMax(""[Дата публикации]"", ""[Объявления архива]"", ""[UserID]='"" & [UserID] & " "' and [Область]='" & Me.Комбинированная105 & "'"")) Is Not Null))" & _ 
"ORDER BY DMax(""[Дата публикации]"",""[Объявления архива]"" ,""[UserID]='"" & [UserID] & ""' и [Область]='" & Me.Комбинированная105 & "'"") DESC "

Уважаемые форумчане данный запрос выполняется очень долго подскажите как можно подругому написать запрос. Думаю что надо один групповой запрос на основаниии другого построить. А написать строку не получается. Подскажите как она должна быть написана. Заранее Благодарен!

[Welshgasman]

Non comprende. Lo siento.

[NoellaG]

Да здравствует Украина

[mike60smart]

Translated:-
Dear Forums this request is executed for a very long time tell us how to write a friend request. I think that one group query should be built on the basis of another. And the line cannot be written. Tell me how it should be written. Thank you in advance!

strSQL = "SELECT Users.Phone 1, Users.UserID, DMax("[Publication Date]",""[Announcements] Archive",""""[UserID]="" & "UserID] & " [Area]=" & Me Combined.("""[ID]","[Archive Announcements]","[UserID]='"" & [UserID] & """ and [Publication Date]="" & Format([Date]," #mm/dd /yyhy h ::nn #& "Format& and"Format([Format]" ID & "ID.("""[Year of Release]","[Archive Announcements]","[UserID]='"" &[UserID] & """ and [Date of publication]="" & Format([Date]," #mm /dd yyyyyh :nn & ") & "Date & "Format & Year" & Combined"
" From Users" & _
" " WHERE ((Users.Phone 1) Is Null) And (("DMax("[Publication date]"", ""[Archive Announcements]", """"[UserID]="" & [UserID] & " and [Area]" & Me.Combined 105) "Not & "Null & ")
"ORDER BY DMax(""[Publication Date]",""[Archive Announcements]","""[UserID]='"" & [UserID] & ""' and [Scope]='" & Me.Combination.