[AccessD] Update query syntax

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



More information about the AccessD mailing list