[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