I am in the process of documenting a number of queries and am looking for a way to print the definition of a querie. I would like to see what I see in design view when I have a querie written.
Note that you can change your query to "SQL View" and copy and paste your SQL code. The SQL code is actually what drives the query and tells it what to do. Design View is just a "prettied-up" display of that SQL code.
Alt-Print Screen will take a screenshot of your query in design view. Perhaps a combination of the screenshot and the sql would be enough documentation for you?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.