Does MS Access support “CASE WHEN” clause if connect with ODBC?

by

Since you are using Access to compose the query, you have to stick to Access’s version of SQL.

To choose between several different return values, use the switch() function. So to translate and extend your example a bit:

select switch(
  age > 40, 4,
  age > 25, 3,
  age > 20, 2,
  age > 10, 1,
  true, 0
) from demo

The ‘true’ case is the default one. If you don’t have it and none of the other cases match, the function will return null.

The Office website has documentation on this but their example syntax is VBA and it’s also wrong. I’ve given them feedback on this but you should be fine following the above example.

More Related Contents:

  1. Address standardization within a database
  2. can we list all tables in msaccess database using sql?
  3. How can I implement SQL INTERSECT and MINUS operations in MS Access
  4. Lightweight SQL database which doesn’t require installation [closed]
  5. SQL: Using NULL values vs. default values
  6. Creating a custom ODBC driver
  7. How can I list the tables in a SQLite database file that was opened with ATTACH?
  8. In MySQL queries, why use join instead of where?
  9. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  10. Transpose latest rows per user to columns
  11. Case expressions in Access
  12. How do I count unique items in field in Access query?
  13. Is there any boolean type in Oracle databases?
  14. Date Difference between consecutive rows
  15. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  16. Using Excel VBA to export data to MS Access table
  17. SQLite – ORDER BY RAND()
  18. Splitting the string in sql server
  19. Need to list all triggers in SQL Server database with table name and table’s schema
  20. What is the purpose of constraint naming
  21. Drop all tables command
  22. How to find a table having a specific column in postgresql
  23. INSERT COMMAND :: ERROR: column “value” does not exist
  24. Comma separated values in a database field
  25. Can SQL Server Express LocalDB be connected to remotely?
  26. What can cause an Oracle ROWID to change?
  27. Why don’t DBMS’s support ASSERTION
  28. Temporal database design, with a twist (live vs draft rows)
  29. How do I perform update query with subquery in Access?
  30. Executing SQL query on multiple databases

Leave a Comment