G
Guest
Is there any way to place a comment inside the sql of a query?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Armen Stein
Is there any way to place a comment inside the sql of a query?
No, but you can add a Description to the query object in Access, which
shows when you click the Details view in the Database Window.
G
Guest
I sometimes add a 'comment' when I am building a query particular a tricky
criteria that I want to build in parts.
In the design view I add a new output field like this --
Comment test: "How now brown cow or the quick brown fox jumped"
criteria that I want to build in parts.
In the design view I add a new output field like this --
Comment test: "How now brown cow or the quick brown fox jumped"
A
Armen Stein
Thats a great idea. It isn't truly a comment, as you indicate with
your quotes, because the query is doing a bit more work and processing
more data. But it's good if you really need it.
Microsoft Access MVP
www.JStreetTech.com
your quotes, because the query is doing a bit more work and processing
more data. But it's good if you really need it.
Armen SteinI sometimes add a 'comment' when I am building a query particular a tricky
criteria that I want to build in parts.
In the design view I add a new output field like this --
Comment test: "How now brown cow or the quick brown fox jumped"
Microsoft Access MVP
www.JStreetTech.com