RE: access iif count

2000-09-28 Thread Jaime Garza
add 'FROM dual' at the end: Access should work as SQL server but I have not tried months ago. Jaime/ -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 11:17 AM To: CF-Talk Subject: access iif count Hi folks, I'm trying to use

RE: access iif count

2000-09-28 Thread Peter Stolz
Garza [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 7:24 PM To: CF-Talk Subject: RE: access iif count Power to the sub queries! FOR SQL Server: SELECT (SELECT Count(*) FROM Survey WHERE success=1) as SuccessYes, (SELECT Count(*) FROM Survey WHERE success=0) as Succes

Re: access iif count

2000-09-28 Thread Deanna L. Schneider
Thanks Jaime, But, it doesn't work. Syntax Error. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923

Re: access iif count

2000-09-28 Thread Deanna L. Schneider
Thanks Peter. That did it. I swear I tried that. Oh well. Brain burp. -Deanna Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI

access iif count

2000-09-27 Thread Deanna L. Schneider
Hi folks, I'm trying to use IIF in a query to count a bunch of yes/no values. Here's what I'm trying that doesn't work (both count the total rows): cfquery name="countyesnos" datasource="#dsn#" SELECT COUNT(IIF (success = 1, 1, 0)) as successyes, COUNT(iif (success = 0, 1, 0)) as successno