?
Solved

Attn Dave Kawliche

Posted on 2001-08-26
3
Medium Priority
?
311 Views
Last Modified: 2012-06-27
Hi Dave,

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.

Your comment:
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
0
Comment
Question by:gillmcd
3 Comments
 
LVL 7

Expert Comment

by:weesiong
ID: 6426210
gillmcd,

try this:

SELECT SurveyName AS [Survey], SurveyAdministrator AS [Administrator], iif(isAnon = 0,'No','Yes') as [Anonymous], iif(isEmail = 0,'No','Yes') as [Email_Notification] from.....

NO space in the fieldname

Regards,
Wee Siong

0
 
LVL 2

Accepted Solution

by:
AccessHelpNet earned 520 total points
ID: 6429471
Glad I could be of some help.

regards,

Dave Kawliche
http://AccessHelp.net
http://1ClickDB.com
0
 

Author Comment

by:gillmcd
ID: 6429905
Thanks again.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question