I was unaware that Access Sql supported Case
statements
unlike Transact-SQL

When you think about it you would create a sql text
string and build this up with CASE options etc.

then open recordset with the concatenated text string.

This of course is what Transact-SQL is doing anyway
parsing the text and resolving into a recordset.


You can of course use cascading IIF statements in
Access SQL and this can often achieve desired results


--- ronp@c... wrote:
> hi,
> 
> I would like to write a Select Case statement inside
> a SQL select query
> string to Access 8.0.
> 
> What's the syntax for that?
>