<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>Kathryn</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I nomally use the query builder. If I read your
request</FONT></DIV>
<DIV><FONT size=2>correctly,I'd use something like</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>"iif(mid$(attend,1, instr(Attend,"=") +1 ) =
'35'"</FONT></DIV>
<DIV><FONT size=2>as your condition </FONT><FONT size=2>and</FONT></DIV>
<DIV><FONT size=2>something like "val(mid$(Attend,instr(Attend,"=") +1 , 1
)"</FONT></DIV>
<DIV><FONT size=2>as your replace statement for Attend35 </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Dave</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=kathryn@bassett.net href="mailto:kathryn@bassett.net">Kathryn
Bassett</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">dbAdvisors (AccessD)</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, June 19, 2003 5:51
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Update query
syntax</DIV>
<DIV><BR></DIV>I have a field called Attend that is text 100 in length. I've
added new fields called Attend25, Attend35 etc and made then all long integers
with zero decimal places. (The numbers will only be one digit as it is usually
just one or two people.)<BR><BR>We'll use the 35th for the example of what I
want to do. I know there is a way using the queries, to take the contents of
Attend, and put it in Attend35. Before I just try to muddle though it, I
thought I'd find out if there is a way to do it thusly:<BR><BR>Current sample
of Attend is:<BR>35=2 30b=2 30a=2 25=2<BR><BR>If Attend contains "35=1" then
put a 1 in Attend35 or if Attend contains "35=2" then put a 2 in
Attend35<BR><BR>So, what would my query look like to do
that?<BR><BR>--<BR>Kathryn Rhinehart Bassett (Pasadena CA)<BR>"Genealogy is my
bag" "GH is my soap"<BR><A
href="mailto:kathryn@bassett.net">kathryn@bassett.net</A><BR><A
href="http://bassett.net">http://bassett.net</A>
<BR><BR>_______________________________________________<BR>AccessD mailing
list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BODY></HTML>