Syntax Error in String in Expression...?

  • Thread starter Thread starter James
  • Start date Start date
J

James

I have written a query which contains an expression which concatenates a
string based on two IIF statements.

When I wrote the query everything executed & saved perfectly. If I execute
the query from an asp page, it executes perfectly.

However, if I try to open the query to modify it in Access, or even run it I
get the above error.

I thought it might be corruption, but have tried importing into clean DB &
the error remains.

Unfortunately the query contains quite a few joins & is fairly long (the SQL
that is), so I would prefer to recover what I have & modify it, rather than
having to rewrite from scratch (not to mention having to remember what
exactly it returns!).


Any other suggestions?

Cheers,

James
 
I have a suggestion:
Open Tools - Options - Tables/Queries tab, and check SQL Server Compatible
Syntax (ANSI 92). Maybe the there is some difference between the SQL
Dialect...
 
Back
Top