Greetings List, I have what for me, keeps getting foggier and foggier. I am tempted to just do this in Access, it would sure be a lot easier but hate to mix this particular MI table with Access. Perhaps I am making it too complicated.
I have an ODD and EVEN column "O_E" formatted as Char 1, in which I wish to evaluate four standard Mapinfo address range fields (FromLeft, ToLeft, FromRight, ToRight) and update the Odd Even column accordingly. An address range would be "ODD" IF the FromLeft, ToLeft fields >0 AND IF The FromRight, ToRight fields = 0 Likewise, the range would be "EVEN" IF the FromRight, ToRight fields >0 AND IF the FromLeft, ToLeft fields = 0 If all four fields FromLeft, ToLeft, FromRight, ToRight have a value, the O_E field would be updated with null or nothing. Ex: --------------------------------------------- FROMLEFT | TOLEFT | FROMRIGHT | TORIGHT | O_E 1 | 9 | 2 | 8 | 1 | 9 | 0 | 0 | O 0 | 0 | 2 | 8 | E ---------------------------------------------- Thanks for any assistance you can provide. __________________________ David W. Reid Mapper Colbert County E 9-1-1 Annex Basement 120 W 5th St Tuscumbia AL 35674 (256) 383-4074 voice (256) 383-5088 fax (256) 810-4149 cell (256) 386-8558 [9-1-1 bus office] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13072
