Commenting out in Microsoft Jet SQL

[Miguel]

I'm programming in a product called MAZE, a school administration program. It uses Microsoft Jet SQL. I would like to be able to comment out sections of SQL while I am testing, but so far no luck. Any suggestions?<br>
Thanks.

 

[bigscouse]

What have you tried? <p>Ged Jones<br><a href=mailto:gedejones@hotmail.com>gedejones@hotmail.com</a><br><a href= > </a><br>

 

[Miguel]

I have tried:<br>
*<br>
*/ /*<br>
{ }<br>
'<br>
REM<br>
<br>
Have you got any other suggestions?<br>

 

[calahans]

You would be better off posting your query in the Access forum for more knowledgeable Access gurus!!!

 

[MapMan]

Try using<br>
<br>
--<br>
<br>
HTH,<br>
<br>
MapMan

 

[amitk]

Has anyone tried writing a query which can determine the parent child relationship of records in a table??? This can be done in Oracle using the START WITH, CONNECT BY Clause. I dont how the same can be achieved on any other database, say DB2. I'm thinking of using some kind of Correlated query for this, but haven't been able to figure it out completely. Can anyone help???