Not able to see the tables of the query

[Pearl1245]

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

[#2 · Accepted solution]

@Pearl1245 

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?

[#3]

@HansVogelaar  Thank you so much for this  I can now see the tables.