Append query will only show SQL view and not Design view

[Kim25]

Hi All,

I am reviewing a accdb file someone else has made. When I try and view the Append query in Design view it won't show it. It will only show the SQL view which I am finding very frustrating. Would the fact that I am working in 2010 cause this problem?

Any suggestions?

 

[SydneyGeek]

It could be one or more of the following:
One of the joins can't be represented graphically.
The query is SQL-specific (UNION, Subquery, Passthrough) -- these cannot be shown graphically either.

Denis