November 13, 2003 at 11:23 pm
How can we use comments in access query like -- in SQL
My Blog:
November 17, 2003 at 8:00 am
This was removed by the editor as SPAM
November 17, 2003 at 9:33 am
Please explain how and where you want to put these comments:
In the database window?
Right mouse click the name of the query. Enter comments in the description, on the view menu select details.
In design view?
I don't think you can
In Sql view?
I don't think you can
In VBA?
Precede comment with an apostrophe '
November 18, 2003 at 9:43 pm
in SQL View
I want to run this query
Select * from Table1
-- Where a= 1
Where a= 1 is the commented line
My Blog:
November 19, 2003 at 4:48 am
As mentioned above, I don't think this is possible in SQL view
November 19, 2003 at 9:56 am
Sorry NO SQL COMMENTS are supported in Jet
* Noel
November 20, 2003 at 11:14 pm
Ok thanks every body
My Blog:
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy