|
|
|
Групповые операции
|
|||
|---|---|---|---|
|
#18+
Люди добрые!Не пинайте сильно ибо чайник я! Есть такой вот запрос: SELECT RptSheet_1.P15 & IIf(Len(nz(RptSheet_1.P15))=0 Or Len(nz(RptSheet_1.P14))=0,""," - ") & RptSheet_1.P14 AS Узел, RptSheet.P15 & IIf(Len(nz(RptSheet.P15))=0 Or Len(nz(RptSheet.P14))=0,""," - ") & RptSheet.P14 AS Входящие, RptSheet2.P15, RptSheet2.P26+"/"+RptSheet2.P27 AS Участок, RptSheet2.P28, RptSheet.P10 AS [Кол_ узел], RptSheet2.P5 FROM RptSheet2 RIGHT JOIN (RptSheet INNER JOIN RptSheet AS RptSheet_1 ON RptSheet.P24 = RptSheet_1.P4) ON RptSheet2.P1 = RptSheet.P2 GROUP BY RptSheet_1.P15 & IIf(Len(nz(RptSheet_1.P15))=0 Or Len(nz(RptSheet_1.P14))=0,""," - ") & RptSheet_1.P14, RptSheet.P15 & IIf(Len(nz(RptSheet.P15))=0 Or Len(nz(RptSheet.P14))=0,""," - ") & RptSheet.P14, RptSheet2.P15, RptSheet2.P26+"/"+RptSheet2.P27, RptSheet2.P28, RptSheet.P10, RptSheet2.P5, RptSheet.P4, RptSheet2.P12, RptSheet.P29, [RptSheet2].[P26]+"/"+[RptSheet2].[P27] HAVING (((RptSheet.P4)<>[RptSheet].[P24]) AND ((RptSheet2.P12)="ОПР") AND ((RptSheet.P29)="ДЕ" Or (RptSheet.P29)="ССИ") AND (([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="07/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="08/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="09/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="10/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="11/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="12/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="13/01")) ORDER BY RptSheet_1.P15 & IIf(Len(nz(RptSheet_1.P15))=0 Or Len(nz(RptSheet_1.P14))=0,""," - ") & RptSheet_1.P14; Только он не выполняется, пишет "Попытка выполнить запрос, который не включает указанное выражение 'Not RptSheet.P4=[RptSheet].[P24] And RptSheet2.P12="ОПР" And... как часть статистической функции или группы" Вообщем в хелпе ничего не понял, книжки не читал и времени нету ((( Просветите, пожалуйста, как побороть ошибку ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 19.11.2004, 12:55:37 |
|
||
|
Групповые операции
|
|||
|---|---|---|---|
|
#18+
В порядке идеи (не проверял): SELECT RptSheet_1.P15 & IIf(Len(nz(RptSheet_1.P15))=0 Or Len(nz(RptSheet_1.P14))=0,""," - ") & RptSheet_1.P14 AS Узел, RptSheet.P15 & IIf(Len(nz(RptSheet.P15))=0 Or Len(nz(RptSheet.P14))=0,""," - ") & RptSheet.P14 AS Входящие, RptSheet2.P15, RptSheet2.P26+"/"+RptSheet2.P27 AS Участок, RptSheet2.P28, RptSheet.P10 AS [Кол_ узел], RptSheet2.P5 FROM RptSheet2 RIGHT JOIN (RptSheet INNER JOIN RptSheet AS RptSheet_1 ON RptSheet.P24 = RptSheet_1.P4) ON RptSheet2.P1 = RptSheet.P2 WHERE (((RptSheet.P4)<>[RptSheet].[P24]) AND ((RptSheet2.P12)="ОПР") AND ((RptSheet.P29)="ДЕ" Or (RptSheet.P29)="ССИ") AND (([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="07/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="08/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="09/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="10/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="11/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="12/01" Or ([RptSheet2].[P26]+"/"+[RptSheet2].[P27])="13/01")) GROUP BY RptSheet_1.P15 & IIf(Len(nz(RptSheet_1.P15))=0 Or Len(nz(RptSheet_1.P14))=0,""," - ") & RptSheet_1.P14, RptSheet.P15 & IIf(Len(nz(RptSheet.P15))=0 Or Len(nz(RptSheet.P14))=0,""," - ") & RptSheet.P14, RptSheet2.P15, RptSheet2.P26+"/"+RptSheet2.P27, RptSheet2.P28, RptSheet.P10, RptSheet2.P5, RptSheet.P4, RptSheet2.P12, RptSheet.P29, [RptSheet2].[P26]+"/"+[RptSheet2].[P27] ORDER BY RptSheet_1.P15 & IIf(Len(nz(RptSheet_1.P15))=0 Or Len(nz(RptSheet_1.P14))=0,""," - ") & RptSheet_1.P14; То, что покрашено цветом, я поменял местами. То, что выделено болдом, изменил. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 19.11.2004, 12:59:39 |
|
||
|
|

start [/forum/topic.php?desktop=1&fid=45&tid=1670248]: |
0ms |
get settings: |
8ms |
get forum list: |
18ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
70ms |
get topic data: |
10ms |
get forum data: |
3ms |
get page messages: |
38ms |
get tp. blocked users: |
1ms |
| others: | 238ms |
| total: | 392ms |

| 0 / 0 |
