Thank you very much.

I have found that the IIF() work fine.

One thing, I am not able to name columns as I need. Without iif I can
use arbitrary names, but once I use function iif the part of the sql
command "... AS country ..." dissapeared and excel use funny names
expr1001, expr1002 and so on. How to fix it?

I am going to ask this question in separate post.

anyway thank you very much.

riso

On Mar 5, 10:12 pm, "merjet" wrote:
It fails because your code is not a valid SQL statement.
These are valid SQL statements:

SELECT employees.EmployeeID, employees.LastName, employees.country
FROM employees WHERE employees.country = 'USA';

SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName,
IIf([Employees]![Country]='USA',1,0) AS Country
FROM Employees;

The latter works in Access and as an SQL statement using ADO or DAO,
but I don't know if it will from Excel in the way you are trying.

Hth,
Merjet