>Hi Erik,
>yes, a bit different question, however on the same idea. The syntax error wasn't from the report . . . the report is small, and I combed it thoroughly.
What line throws the error? Where are you running this SQL from? BTW, you probably want to use the INTO CURSOR clause here to prevent a browser window from opening when the query completes.
Erik Moore
Clientelligence