If this is Access I don't think the CASE statement is available against the JET engine.. you might want to take a look at the IIF Statment instead..
Select (IIF([Index1] ='XXX','11',[Index1])) As Expr FROM [01_INFO]")
|
Results 1 to 10 of 10
Thread: DAO, SQL Case StatementThreaded View
|
Click Here to Expand Forum to Full Width |