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 ...)
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 ...)