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.
 
Back
Top