access写sql，总是提示错误。请高手帮忙

[dellxng2000]

请教各位高手.
我用MICROSOFT ACCESS写SQL。语句如下：

SELECT SHEET1.CONSIGNEE, SUM(SHEET1.TEU) AS TEU, SHEET1.TRADE, SHEET1.[P/C]
FROM [SELECT *
FROM SHEET1
WHERE SHEET1.[P/C] = 'C' and SHEET1.TRADE='AEX'
ORDER BY SHEET1.CONSIGNEE DESC];
GROUP BY SHEET1.CONSIGNEE, SHEET1.TRADE, SHEET1.[P/C]
ORDER BY SUM(SHEET1.TEU) DESC;

但是总是出现错误提示，如下：
Invalid bracketing of name'SELECT *
FROM SHEET1
WHERE SHEET1.[P/C'

请教高手，这是怎么回事？该如何解决，先谢谢了

[wwwwb]

SELECT SHEET1.CONSIGNEE, SUM(SHEET1.TEU) AS TEU, SHEET1.TRADE, SHEET1.[P/C]
FROM (SELECT *
FROM SHEET1
WHERE SHEET1.[P/C] = 'C' and SHEET1.TRADE='AEX'
ORDER BY SHEET1.CONSIGNEE DESC)
GROUP BY SHEET1.CONSIGNEE, SHEET1.TRADE, SHEET1.[P/C]
ORDER BY SUM(SHEET1.TEU) DESC;

[dellxng2000]

成功，谢谢

[dellxng2000]

还是有问题。写进去没事，可是经常还是报以上的错误。
而且，点设计也看不了SQL语句了。我该怎么办？

[dellxng2000]

错误的语句

SELECT SHEET1.CONSIGNEE, SUM(SHEET1.TEU) AS TEU, SHEET1.TRADE, SHEET1.[P/C]
FROM [SELECT *
FROM SHEET1
WHERE SHEET1.[P/C] = 'C' and SHEET1.TRADE='AEX'
ORDER BY SHEET1.CONSIGNEE DESC]. AS [%$##@_Alias]GROUP BY SHEET1.CONSIGNEE, SHEET1.TRADE, SHEET1.[P/C]
ORDER BY SUM(SHEET1.TEU) DESC;

我明明是按照你给的贴进去，可是系统怎么自己改生上面的了。真奇怪

[wwwwb]

ACCESS自行生成的，去掉即可

[dellxng2000]

我知道是access自动生成的。但是，我不能每次都重新贴一遍源码吧。
有什么好办法解决么

[wwwwb]

没什么好办法

[dellxng2000]

真的很奇怪，为什么会出现这样的问题。编译能过去。但是运行一次以后，系统就自动加了语句。然后，再次运行就提示错误。难道这个是acess的bug？解决不了了？？