Forum Discussion
Pearl1245
Jul 17, 2020Copper Contributor
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 t...
- Jul 17, 2020
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
Jul 17, 2020MVP
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?
Pearl1245
Jul 18, 2020Copper Contributor
HansVogelaar Thank you so much for this
I can now see the tables.