title: default value for switch in access 2007
body: <p>I am using switch statement in access 2007, i want to know how I can specify default value</p>
  
  <pre><code>select 
    switch
    (
    MyCol = 1, 'Value is One',
    MyCol = 2, 'Value is Two'
    ) from MyTable
  </code></pre>
  
  <p>Thanks</p>