[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  

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com