Cannot open query in designer ?

G

Guest

I have some queries that refuse to open in the designer. I get a messge 'join
expression not supported'. These queries use to open and Access used to
remove parentheses I has inserted, I was able to re-add the parentheses and
save and run the queries. Now it refuses to open them at all. I'm using
Access 2003 in Access 2000 mode. Can anyone tell me how to get around this?
These queries have a LEFT JOIN ON ... AND ... clause, I used to be able to
make them work by coding LEFT JOIN ON (... AND ...)
 
R

Rick B

I think certain types of queries (union for example) can't be opened in
design view. They must be worked with SQL view. These are "sql-specific"
queries.

Typically though, you won't see an error message, you will simply not have
the option in your menu to go to design view. This issue may be a different
issue.
 
G

Guest

BY 'design view' I meant SQL view since that is how they were created. When I
click on the query and then click 'design' I get 'join expression not
supported' and the query source is not shown for me to make corrections. I
need to know how to get my SQL source?
 
J

John Spencer (MVP)

Open the immediate window (Control + G)
Type in something like the following and then press return

?Currentdb().querydefs("NameofQuery").SQL

That should print the SQL in the immediate window

You can copy and paste that into a new query window (SQL view) and then
manipulate it as needed to make it work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top