SQL View is Blank (1 Viewer)

[mstorer]

I have a union query which is part of a multiple step process to retrieve our data. I need to make a change to the WHERE clause of one of the union's select statements. However, when I go into the SQL view of the query, the window is blank. Oddly, the query runs fine as is. Additionally, I can create a new query and see all of the fields in my union query when I "Show Table" in the regualar QBE window.

I have tried repairing the database. As well, I have created a new database and imported all of the necessary objects and imported the query only to again receive a blank SQL view window.

Any thought? Could this be just an odd hicup with the server? Thanks in advance for any insight.

- Matt

 

[mstorer]

You may disregard this thread. I moved the database to a different server and now I can see my SQL. It must be a hicup on the server. Thanks for any consideration given to its solution.

- Matt