SOLVED

Not able to see the tables of the query

%3CLINGO-SUB%20id%3D%22lingo-sub-1529144%22%20slang%3D%22en-US%22%3ENot%20able%20to%20see%20the%20tables%20of%20the%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529144%22%20slang%3D%22en-US%22%3E%3CP%3EAm%20hoping%20someone%20has%20had%20this%20problem%20before%20and%20can%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20know%20how%20I%20can%20get%20to%20the%20tables%20for%20this%20query%20as%20I%20am%20not%20able%20to%20scroll%20up%20to%20the%20top%20of%20them.%20Please%20see%20screenshot%20for%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1529144%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529800%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20able%20to%20see%20the%20tables%20of%20the%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529800%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F731893%22%20target%3D%22_blank%22%3E%40Pearl1245%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20the%20following%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESwitch%20to%20SQL%20view.%3C%2FLI%3E%0A%3CLI%3ESelect%20the%20entire%20SQL%20text%20and%20copy%20it.%3C%2FLI%3E%0A%3CLI%3EOn%20the%20Create%20tab%20of%20the%20ribbon%2C%20click%20Query%20Design.%3C%2FLI%3E%0A%3CLI%3EClose%20the%20Add%20Tables%20dialog.%3C%2FLI%3E%0A%3CLI%3ESwitch%20to%20SQL%20view.%3C%2FLI%3E%0A%3CLI%3EDelete%20the%20existing%20text%2C%20then%20paste%20the%20copied%20SQL.%3C%2FLI%3E%0A%3CLI%3ESwitch%20to%20Design%20view.%3C%2FLI%3E%0A%3CLI%3ECan%20you%20now%20see%20the%20tables%3F%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530722%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20able%20to%20see%20the%20tables%20of%20the%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530722%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%20Thank%20you%20so%20much%20for%20this%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fstareyes_40x40.gif%22%20alt%3D%22%3Astareyes%3A%22%20title%3D%22%3Astareyes%3A%22%20%2F%3E%20I%20can%20now%20see%20the%20tables.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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)
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?

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