'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