I need to know how to use SQL switch fuction in MS Acces. Simple SELECT query is like this but it is not working,
SELECT Switch(Habitat=T,"Terrestrial",Habitat=A,"Aquatic" ,Habitat=E,"Epiphytic")
FROM MainCharacteristics;
I need to display "Terrestrial" insted of "T" like wise,
Pls help,