Forum Discussion
Solved
Not able to see the tables of the query
Am hoping someone has had this problem before and can help.
I need to know how I can get to the tables for this query as I am not able to scroll up to the top of them. Please see screenshot for the problem.
Thanks in advance
Try the following:
- Switch to SQL view.
- Select the entire SQL text and copy it.
- On the Create tab of the ribbon, click Query Design.
- Close the Add Tables dialog.
- Switch to SQL view.
- Delete the existing text, then paste the copied SQL.
- Switch to Design view.
- Can you now see the tables?
Try the following:
- Switch to SQL view.
- Select the entire SQL text and copy it.
- On the Create tab of the ribbon, click Query Design.
- Close the Add Tables dialog.
- Switch to SQL view.
- Delete the existing text, then paste the copied SQL.
- Switch to Design view.
- Can you now see the tables?
HansVogelaar Thank you so much for this
I can now see the tables.
