fields not visible in query design - Urgent

[prabhu]

Hello all,
i am using Access 2000, today suddenly the fields and table area (bottom section of the query) in my query design is not visible. I can see only the tables (top section of the query) whihc i am using in this query. Can someone tel me how to get it back? i got lot of formulas in it.

 

[HiTechCoach]

Hello all,
i am using Access 2000, today suddenly the fields and table area (bottom section of the query) in my query design is not visible. I can see only the tables (top section of the query) whihc i am using in this query. Can someone tel me how to get it back? i got lot of formulas in it.

Is there a vertical scroll bar on the right side of the query window? If there is, try scrolling down.

 

[prabhu]

No, i tried but nothing available until the bottom.

 

[DCrake]

What happens if you run the query in datasheet view?

If it works ok then view the query in sql view and copy the sql and create a new query by pasting in the sql in to the query.

 

[Sonny Jim]

I am dealing with the same thing, & have copied the SQL into a new query. The Design View is now visible.

• Why or how does the Design View disappear like this?

• Will deleting the old query & renaming the new query with the old name work without unexpected problems?