default value for switch in access 2007

Question

I am using switch statement in access 2007, i want to know how I can specify default value

select 
  switch
  (
  MyCol = 1, 'Value is One',
  MyCol = 2, 'Value is Two'
  ) from MyTable

Thanks

Vikram Jain · Accepted Answer · 2013-04-30T06:55:21.360

25

SELECT
Switch(MyTable.[MyCol]='1','Terrestrial',
MyTable.[MyCol]='2','Value is two',MyTable.[MyCol]='3','Value is three',
True,'Error') AS ColumnName
FROM MyTable;

edited Apr 30 '13 at 06:55

answered Apr 30 '13 at 06:49

Vikram Jain

5,498
1
19
31

i am asking for ms-access querry – Mandeep Singh Apr 30 '13 at 06:50

score 14 · Answer 2 · answered Apr 30 '13 at 06:59

14

select 
  switch
  (
  MyCol = 1, 'Value is One',
  MyCol = 2, 'Value is Two'
  True,"Default"
  ) from MyT

Refer:

http://www.utteraccess.com/forum/Switch-statement-default-t453140.html

answered Apr 30 '13 at 06:59

Freelancer

9,008
7
42
81

score 0 · Answer 3 · answered Apr 19 '18 at 07:43

The syntax for the Swich command is:

Switch(TestCase1, Result1, TestCase2, Result2, {As many more TestCases and Results as you need...}, DefaultResult)

Note that the DefaultResult is an optional parameter and will provide a response in the event that the actual data does not match any of the Test Cases.

default value for switch in access 2007

3 Answers3