I was unaware that Access Sql supported Case
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:
> 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?