Great News. I hate doing SQL with Queries because the error messagge
are so vague. I either use the ADO to connect to a database (error
messages are a little better, only a little). the other trick I use
which may not be very easy in your SQL is to use the Query Editor. Once
You get your simple query you can use the Query Editor by selecting any
cell where data has been returned. Then go to the Data menu and you
will see the edit query option enabled. In the query editor there is a
SQL button that opens a new window. Yo can acutall type in any query
you want and the eidtor will tell you if your SQL is valid and return
data into the window.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=198559

http://www.thecodecage.com/forumz