sql syntax error

[SMAlvarez]

Why does the following sql code gives a syntax error in Access? How can I fix it?

SELECT SUM(CASE WHEN City = 'Sandnes' THEN 1 ELSE 0 END) as FieldNeeded1
FROM Persons;

[thhui]

Try this instead:-

SELECT Sum(IIf([City]='Sandnes',1,0)) AS Sum
FROM Persons;