[AccessD] Update query syntax

If the string was found, then Instr() gives you the position number of
where it starts, else it returns 0.  So, if that number is >0, you have
found what you are looking for and the <truepart> will be executed.
Otherwise, you will execute the <falsepart>.  Thus, <truepart> is where
you say what to do when the string is found, and <falsepart> is where
you say what to do if the string is not found.  If either takes more
than one line of code, you should encapsulate it in a procedure and call
the procedure in <truepart> or <falsepart>.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Kathryn Bassett [mailto:kathryn at bassett.net] 
Sent: Wednesday 2003 Jun 25 11:01
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Update query syntax

Problem is that I still don't understand the parts. What is >0 about?
What goes in <truepart> and what goes in <falsepart>? Kathryn

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte 
> Foust
> Sent: 25 Jun 2003 8:51:AM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Update query syntax
> 
> 
> Kathryn,
> 
> Now you're beginning to see why so few of us ever bother with the 
> builder.  It's far easier to use intellisense to create the expression

> or look at the object browser.
> 
> Try
> 
> IIF(Instr([Muir63]![attend],"35=2")>0,<truepart>, <falsepart>)
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: Kathryn Bassett [mailto:kathryn at bassett.net]
> Sent: Wednesday, June 25, 2003 7:37 AM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Update query syntax
> 
> 
> I'm starting to get there, but...
> 
> After double clicking on IIF, I get:
> IIf (<expr>, <truepart>, <falsepart>)
> Then I highlighted <expr> and clicked Mid$ so I now have:
> IIf ( Mid$ (<stringexpr>, <start>, <length>) , <truepart>,
<falsepart>) 
> Highlight <stringexpr> and click on tables > Muir63 as the table and
> attend as the field so I now have: IIf ( Mid$ ( [Muir63]![attend] ,
> <start>, <length>) , <truepart>, <falsepart>) 
> 
> >From there, I'm lost again. Since I'm deleting all the thread leading
> >to this point, I'll recap. The field I'm selecting FROM is attend,
and
> here is a typical content:
> 35=2 30b=2 30a=2 25=2
> So, for my criteria, I want
> if [Muir63]![attend] contains 35=2
> so, which of the <start>, <length>, <truepart>, and <falsepart>) gets
> what? It seems to me that there are too many parts.
> 
> Keep in mind that 35=2 could be anywhere in the string, not just at 
> the beginning. But there won't be any spaces like 35 = 2, or anything 
> like that, always the exact phrase of 35=2.
> 
> Thanks for helping,
> 
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net