What is the correct syntax for using a CASE function in a SQL statement that has 4 cases to evaluate when running against an Access 2000 database? In
VB the CASE would be as follows:
SELECT CASE Plan
CASE "MON"
SupPlan = Amt
CASE "QUR"
SupPlan = Amt * 4
CASE "Ann"
SupPlan = Amt * 12
CASE "NON"
SupPlan = 0
END SELECT
How do I do this same thing with SQL in Access?