how to print query's sql view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access97 how can I print the SQL code for a query. In the Design of the
query, I go to SQL view and all of the code is highlighted, but I do not see
any way to print it directly from there. I can copy and paste it elsewhere
for printing, but I would think it can be done from within the Access product.
 
In Access97 how can I print the SQL code for a query. In the Design of the
query, I go to SQL view and all of the code is highlighted, but I do not see
any way to print it directly from there. I can copy and paste it elsewhere
for printing, but I would think it can be done from within the Access product.
Click to expand...

Tools + Analyze + Documenter
Select the query and then Options. Unselect everything you can except
SQL.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Print Files from Query Results 0
Update Table Field Value with SQL Query 2
SQL query 1
SQL View 5
Access 2010 append query to SQL is very slow 0
Going Crazy! Form Datasheet does not reflect changes to SQL query 4
Am I disturbing a machine in production floor if I access its database remotely? 4
Pass Through Query .sql query 3

Back
Top