Access 2007 SQL the default value for switch

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 -> SELECT Switch(MyTable.[MyCol]=’1′,’Terrestrial’, MyTable.[MyCol]=’2′,’Value is two’,MyTable.[MyCol]=’3′,’Value is three’, True,’Error’) AS ColumnName FROM MyTable; […]

Read More…