query grid

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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.
Click to expand...

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]
 
Back
Top