Access Equivalence to SELECT CASE WHEN Syntax

  • Thread starter Thread starter Simon Shutter
  • Start date Start date
S

Simon Shutter

I'm used to the SELECT CASE syntax in SQL Server. What is the best
equivalent functionality in Access? Do I have to use IIf statements? (I
don't think I can use a cross tab because I need to force a fixed number of
columns in the output).

Tx
 
Simon said:
I'm used to the SELECT CASE syntax in SQL Server. What is the best
equivalent functionality in Access? Do I have to use IIf statements? (I
don't think I can use a cross tab because I need to force a fixed number of
columns in the output).

Tx
Click to expand...

IIf(expr, truepart, falsepart)
Switch(expr-1, value-1[, expr-2, value-2 … [, expr-n,value-n]])
Choose(index, choice-1[, choice-2, ... [, choice-n]])

hth PerL
 
Tx, PerL

Per Larsen said:
Simon said:
I'm used to the SELECT CASE syntax in SQL Server. What is the best
equivalent functionality in Access? Do I have to use IIf statements? (I
don't think I can use a cross tab because I need to force a fixed number of
columns in the output).

Tx
Click to expand...

IIf(expr, truepart, falsepart)
Switch(expr-1, value-1[, expr-2, value-2 … [, expr-n,value-n]])
Choose(index, choice-1[, choice-2, ... [, choice-n]])

hth PerL
Click to expand...
 
Back
Top