i am getting a syntax error when trying to run an access select query - the query works fine until i include this Switch statement;
genderStatus: Switch([gender]="M","Male",[gender]="F","Female",[gender]="X","Cross gender")
should this sql statement work?
genderStatus: Switch([gender]="M","Male",[gender]="F","Female",[gender]="X","Cross gender")
should this sql statement work?