Not able to see the tables of the query

New Contributor

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 Replies
best response confirmed by Pearl1245 (New Contributor)


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?

@Hans Vogelaar  Thank you so much for this :stareyes: I can now see the tables.