Solved

Attn Dave Kawliche

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
An ASP query I cannot work out... 2 46
Out the count variables 6 53
CSS Question.. 3 85
Need help editing script 3 72
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

815 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

11 Experts available now in Live!

Get 1:1 Help Now