Solved

Attn Dave Kawliche

Posted on 2001-08-26
3
298 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 130 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
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…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now