Solved

Attn Dave Kawliche

Posted on 2001-08-26
3
306 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
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…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

691 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