Re: access iif & count

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 53706

Re: access iif & count

Nope, Peter, that doesn't work either. Thanks for the try. -Deanna Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-

Re: access iif & count

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

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 SuccessNo, (SELECT Count(*) FROM Survey WHERE OtherFlag=32

RE: access iif & count

try this: SELECT successyes = SUM(CASE success WHEN 1 THEN 1 ELSE NULL END), successno = SUM(CASE success WHEN 0 THEN 1 ELSE NULL END) FROM survey P. -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 2:17 PM To: CF-Tal

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 SuccessNo, (SELECT Count(*) FROM Survey WHERE OtherFlag=32) as CountThirtyTwos For Oracle, same thing but you ad