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'

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

[slysmart]

这个问题直接去论坛access版块去问好了

[dellxng2000]

ok,tks

[-晴天]

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 SHEET1
GROUP BY SHEET1.CONSIGNEE, SHEET1.TRADE, SHEET1.[P/C]
ORDER BY SUM(SHEET1.TEU) DESC;