CASE Expressions

[torok]

Does Access support CASE expressions in SQL yet, like SQL Server? As detailed here

 

[Mile-O]

Just make a function with the Select Case structure and use the function in your query to determine the value of a calculated field.

 

[torok]

Thanks to both of you for the responses. I didn't know you cuold use IIF in SQL expressions.... I'll look into making the function as well (though I'm not sure how to incorporate a function into a query yet).

Again, thanks for your time