Attn Dave Kawliche
Posted on 2001-08-26
Please post a reply to this so that I can transfer my remaining points - you answered my second question before I even asked it - many thanks.
I think the problem is that CASE is SQL Specific syntax and Access uses the iif() function.
I think the end result you want should look like this:
SELECT SurveyName AS [Survey], SurveyAdministrator AS [Administrator], iif(isAnon = 0,'No','Yes') as
[Anonymous], iif(isEmail = 0,'No','Yes') as [Email Notification], 'edit
/ delete / view results / view details' AS [Action] FROM Survey ORDER BY SurveyName