Yeah, I was thinking Access had a TSQL-like Case statement.

Post #92,028 by mmoffitt 3/26/03 9:06:36 PM Reply	Yeah, I was thinking Access had a TSQL-like Case statement. I'm almost sure they did, but the last time I wrote an Access report was 1998 with Access 97. I don't have a copy installed (still doesn't run on Linux :-) but I'm almost sure there used to be a CASE access statement. And you're right, worked similar to Switch. Could be Switch (like in C) that I was thinking about, but I could swear it was CASE. Okay, now I'm gonna have to look it up. bcnu, Mikem Osama bin Laden's brother could fly in US airspace 9/15/01, but I had to wait for FBI and CIA background checks, 'nuff said?
Post #92,042 by ChrisR 3/26/03 9:16:09 PM Reply	IIRC the queries do support it. But the Switch() function above is a VBScript function.
Post #92,043 by jbrabeck 3/26/03 9:16:46 PM Reply	Yes Access has a Case statement I'm at home now and don't have Access loaded here. Work requirement so I taught myself how to get around in it last summer. I've used the Case statement on events on forms. Paradox still has the IIF([field]=x,true,false). To make it work as requested would have been IIF([Field]=1,"Yes",IIF(Field]=2,"No",IIF([Field]=9,"Unknown","Bad Value"))) I may have seen the IIF still in Access, but I'm not sure. The online help isn't a very good way to learn. Knowing OPAL helped cuz I knew that it could be done... Oh well, still have my Paradox clients to program in a decent language. [link\|mailto:jbrabeck@attbi.com\|Joe]
Post #92,050 by mmoffitt 3/26/03 9:25:51 PM Reply	Yeah, I remember IIF in Access. But it gets hard as hell to read if you're doing more than 2 or 3 checks. IIRC, that's when I looked up the CASE Access statement. bcnu, Mikem Osama bin Laden's brother could fly in US airspace 9/15/01, but I had to wait for FBI and CIA background checks, 'nuff said?
Post #92,119 by Meerkat 3/27/03 3:00:36 AM Reply	DECODE would do it, if Access has it, that is. I'm posting from home, not work, so I can't check. I've used Decode on Oracle, and RedBrick, so it's not some freaky single-vendor proprietary thing. Maybe it's some freaky two-vendor proprietary thing :) John. Busy lad.
Post #92,136 by jbrabeck 3/27/03 8:20:11 AM Reply	IIF, Case and Switch. No Decode Back in the office. Just checked. [link\|mailto:jbrabeck@attbi.com\|Joe]

Welcome to IWETHEY!