SQL Server uses "Transact SQL" (often called TSQL), and is not compatible
with MS Query or MS Access.

P


"Russ" wrote in message
...
I have a SQL statement that runs perfectly in SQL Server's
Query Analyzer (includes a COMPUTE ... BY statement). When
I run it in Query Analyzer it works, when I run it in
Excel's Microsoft Query box, it only returns the first
group and doesn't do a compute. Is there a limitation to
the extended SQL that I can use within Excel?

Thanks