Quote:
Originally posted by Moskie
Want to know what the problem was?
Access doesn't support case statements!
Kill me now. 
|
Access's default SQL doesn't support a lot of things.
Will it work as a pass-through query? We do a lot of this where I work when someone needs Access to interact with an outside database. Access tries to format all SQL into Access-deformed-SQL unless you specify that the query is a pass-through query. (Not sure if this will help if your data is in Access as well).
w0