I want to make a CASE-statement in MS Access 2000, but I don't know the syntax for it! This how it's done in SQL Server:
SELECT 'Price Category' = CASE
WHEN price IS NULL THEN 'Not yet priced'
WHEN price < 10 THEN 'Very Reasonable Title'
WHEN price >= 10 and price < 20 THEN 'Coffee Table Title'
ELSE 'Expensive book!'
ORDER BY price