Getting the QL code when I click on a query name in nav window to get design view.

[Lou_Reed]

When I click on a query name in the navigation windows to get the design view, I get the SQL code instead.

That could not be right, the SQL code is clearly not the design view that I am seeking. What is going

on here? What am I doing wrong?

I have many queries in navigation view that when I click to get the navigation view, that is clearly

what I get with this exception mentioned above.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed.

[aytee111]

(a) it is a pass-thru query
(b) it is a Union query
(c) the tables are missing

[Lou_Reed]

I am not sure and I would have to check. I will get back to you.

Respectfully,

Lou Reed

[Lou_Reed]

Okay, here is the SQL that this maneuver keeps on giving me. I would rather have the query's design view.

SELECT tblTelework.TeleworkID AS ContractID, tblTelework.PersonnelID, tblTelework.Expiration, tblTelework.isActive, "Telework" AS Version
FROM tblTelework
WHERE (((tblTelework.isActive)=True))
UNION SELECT tblPropertyPass.PropPassID AS ContractID, tblPropertyPass.PersonnelID, tblPropertyPass.Expiration, tblPropertyPass.isActive, "Property" AS Version
FROM tblPropertyPass
WHERE (((tblPropertyPass.isActive)=True));

Maybe, this SQL code can answer your question.

Respectfully,


Lou Reed

[aytee111]

I do not have a question - you do!

[Lou_Reed]

That is very true. Sorry about my presumption. However, since I am unsure as to what the following are:

(a) it is a pass-thru query
(b) it is a Union query
(c) the tables are missing

I thought that some help could be obtained by including the only
thing that could possibly matter and that is the SQL code.

I always thought it was quite easy going from query design view
to SQL code and back. It was until I ran up against this issue.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[aytee111]

I was attempting to get you to think for yourself and learn about queries. Under "Design" there are different query types, is any one selected? Are there any clues inside the SQL itself that you can read and will point you to the answer?

[CJ_London]

perhaps this is a clue?

...
WHERE (((tblTelework.isActive)=True))
UNION SELECT tblPropertyPass...

[Lou_Reed]

It seems like it. I am trying to figure out the Access db program. I did not create it, I only got the db a few days ago from another analyst.
It seems that would be significant clue so let me work on it awhile and I will get back to you.

Thanks for your help.

Respectfully,

Lou Reed