IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Yeah, I remember IIF in Access.
Post #92,050
by mmoffitt
3/26/03 9:25:51 PM
Reply
New 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
New 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
New IIF, Case and Switch. No Decode
Back in the office. Just checked.
[link|mailto:jbrabeck@attbi.com|Joe]
     'nother Access question. - (acagle) - (23) - March 26, 2003, 12:36:51 PM EST
         Tools->Relationships - (bepatient) - March 26, 2003, 12:52:54 PM EST
         Try this - (jbrabeck) - (17) - March 26, 2003, 02:03:59 PM EST
             Perfect! Thanks! -NT - (acagle) - March 26, 2003, 03:56:33 PM EST
             Ooh...I like that... - (bepatient) - (15) - March 26, 2003, 04:15:29 PM EST
                 Guess I aint as bad as I thought! - (jbrabeck) - (14) - March 26, 2003, 04:42:38 PM EST
                     Been a while since I used Access, but. - (mmoffitt) - (10) - March 26, 2003, 07:56:15 PM EST
                         Case statement - (orion) - (9) - March 26, 2003, 08:32:46 PM EST
                             Not that one. - (mmoffitt) - (8) - March 26, 2003, 08:35:00 PM EST
                                 SQL construct - (ChrisR) - (7) - March 26, 2003, 09:03:39 PM EST
                                     Still there but only for two options -NT - (tseliot) - March 26, 2003, 09:06:14 PM EST
                                     Yeah, I was thinking Access had a TSQL-like Case statement. - (mmoffitt) - (5) - March 26, 2003, 09:06:36 PM EST
                                         IIRC the queries do support it. - (ChrisR) - March 26, 2003, 09:16:09 PM EST
                                         Yes Access has a Case statement - (jbrabeck) - (3) - March 26, 2003, 09:16:46 PM EST
                                             Yeah, I remember IIF in Access. - (mmoffitt) - (2) - March 26, 2003, 09:25:51 PM EST
                                                 DECODE would do it, if Access has it, that is. - (Meerkat) - (1) - March 27, 2003, 03:00:36 AM EST
                                                     IIF, Case and Switch. No Decode - (jbrabeck) - March 27, 2003, 08:20:11 AM EST
                     Yes you are. - (tseliot) - (2) - March 26, 2003, 09:08:02 PM EST
                         Agree, but... - (jbrabeck) - (1) - March 26, 2003, 09:21:29 PM EST
                             Then you have one of four choices - (tseliot) - March 28, 2003, 04:34:34 PM EST
         Okay, here's another one: - (acagle) - (1) - March 27, 2003, 12:47:38 PM EST
             ="A" & Chr(13) & Chr(10) & "B" - (ChrisR) - March 27, 2003, 12:58:28 PM EST
         Does the Tab key have any special meaning to it? - (acagle) - (1) - March 28, 2003, 03:59:19 PM EST
             Check the properties - (jbrabeck) - March 29, 2003, 08:10:39 AM EST

Sittin' on the Group W bench.
147 ms