I was trying to use the case function from MySql, such as:
SELECT
`transaction amount`.`Donor ID`,
CASE WHEN `interestlevel` THEN `InterestLevel`
WHEN `payment type`.`Category`=3 THEN 4
WHEN `program names`.`Program Category`=1 THEN 9
WHEN `program names`.`Program Category`=2 THEN 6
WHEN `program names`.`Program Category`=3 THEN 6
WHEN `program names`.`Program Category`=4 THEN 11
WHEN `program names`.`Program Category`=5 THEN 9
END AS `Interest Level`
FROM ......
When I enter this in the text area of quey and then try to switch to the design view I get the following error message:
Unable to parse query text
Running the query produces the expected results, though.