Kathryn Bassett
kathryn at bassett.net
Wed Jun 25 11:45:13 CDT 2003
And of course, that's why I'm separating it out :) !!! Kathryn (and no, I don't have any 35=20, but good point to remember for future). > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte > Foust > Sent: 25 Jun 2003 9:24:AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Update query syntax > > > The one thing you'll have to watch out for is if you had something in > your table like "35=20", which will also trigger the <truepart> of you > Iif. That's one of the ugly reasons it is a BAD idea to put multiple > pieces of information in the same field, it's sooooo hard to parse out > reliably. > > Charlotte Foust