[AccessD] Update query syntax

is it save to say whatever figure after the 35= is the figure you want to go
in the 35 column?  If so, this should do it.

update tablename set [Attend35] = mid(attend,4) where left(attend,3) like
"35="

HTH
Selina


----------------------------------------------------------------------------
---- Selina Iddon selina at easydatabases.com.au Ph: 0414 225 265 Easy Access
Databases
----- Original Message ----- 
From: "Kathryn Bassett" <kathryn at bassett.net>
To: "dbAdvisors (AccessD)" <accessd at databaseadvisors.com>
Sent: Friday, June 20, 2003 7:51 AM
Subject: [AccessD] Update query syntax


> 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.)
>
> 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:
>
> Current sample of Attend is:
> 35=2 30b=2 30a=2 25=2
>
> If Attend contains "35=1" then put a 1 in Attend35 or if Attend contains
"35=2" then put a 2 in Attend35
>
> So, what would my query look like to do that?
>
> --
> 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
>
>