is it possible to comment code out in the sql window in access?
+1
A:
No. You cannot have any extraneous text in MS-Access (JET-SQL).
You can make some constraints ignored, eg.
Where
name = "joe"
OR
(state = "VA" AND 1=0)
But that technique is a rather limited way to hide existing SQL
MatthewMartin
2010-06-30 18:58:07
Just double checked in Office 2010. You can't. using -- like in TSQL would raise a "Syntax error (missing operator) ..."
MatthewMartin
2010-06-30 19:00:43