query grid

[Guest]

I have an Access database on our server. Someone has created a query, but
when I open it in design view all I can see are the two tables, the grid is
not showing. I can see the grid when I create a new query. It would be
helpful to view the grid design in the created table, it has some complex
critera created. any solutions, Thanks in advance. I am at a lost.

 

[Nonprofit Tech via AccessMonster.com]

Open the problem query. Change to SQL view. Select the entire SQL statement
and copy it.
Create a new query in design view. Select any table, makes no difference.
Change this new query to SQL view. Delete the current SQL statement and
past in the one you copied.
Change the new query back to design view.
Voila! You should see the grid.

 

[John Vinson]

I have an Access database on our server. Someone has created a query, but
when I open it in design view all I can see are the two tables, the grid is
not showing. I can see the grid when I create a new query. It would be
helpful to view the grid design in the created table, it has some complex
critera created. any solutions, Thanks in advance. I am at a lost.

Try selecting SQL view, and then going back to design view. Or, they
might have unintentionally just dragged the size of the grid to squash
it all together.

John W. Vinson[MVP]