-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


êàê ïðàâèëüíî çàäàòü óñëîâèå äëÿ ïåðåêðåñòíîãî çàïðîñà?

Ïÿòíèöà, 05 Àâãóñòà 2016 ã. 16:50 + â öèòàòíèê
êîëëåãè, ïîäñêàæèòå ïîæàëóéñòà!
Åñòü çàïðîñ
TRANSFORM Last(ÐÌ_äëÿÏåðåêðåñòíîãîÇàïðîñà.ÎñòàòîêÏîñëåÈçìåíåíèÿ) AS [Last-ÎñòàòîêÏîñëåÈçìåíåíèÿ]
SELECT ÐÌ_äëÿÏåðåêðåñòíîãîÇàïðîñà.DT
FROM ÐÌ_äëÿÏåðåêðåñòíîãîÇàïðîñà
WHERE ÐÌ_äëÿÏåðåêðåñòíîãîÇàïðîñà.DT>=cdate([Ôîðìû]![ÐÌ_ÏåðåêðåñòíûéÎò÷åò]![fi_DateBegin])
GROUP BY ÐÌ_äëÿÏåðåêðåñòíîãîÇàïðîñà.DT
PIVOT ÐÌ_äëÿÏåðåêðåñòíîãîÇàïðîñà.Íàçâàíèå;


êàê ïðàâèëüíî çàäàòü óñëîâèå äëÿ ïåðåêðåñòíîãî çàïðîñà?
Ðóãàåòñÿ íà ñòðîêó
WHERE ÐÌ_äëÿÏåðåêðåñòíîãîÇàïðîñà.DT>=cdate([Ôîðìû]![ÐÌ_ÏåðåêðåñòíûéÎò÷åò]![fi_DateBegin])
- íå ðàñïîçíàåòñÿ ÿäðîì áä êàê äîïóñòèìîå ïîëå
Çàðàíåå ñïàñèáî çà ëþáóþ ïîìîùü!

http://www.sql.ru/forum/1225734/kak-pravilno-zadat-uslovie-dlya-perekrestnogo-zaprosa


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó