Hi all,

I want to create in Excel (via data/import new external data/new
database query) a query from MS Access database using statement case.
MS query still complains. I tried something like this example (using
Northwind sample database):

SELECT employees.EmployeeID, employees.LastName,
case
when employees.country = 'USA' then 1
else 0
end
FROM Nwind.employees employees


What is wrong? The Microsoft query still complains that it didn't
expect 'employees' after the select column list.

I have also tried several variant like "... code = case ...." or ....
end as 'code'..." but no improvement.


thank you very much for any help.

riso