dave sharpe
davesharpe2 at cox.net
Thu Jun 19 18:56:37 CDT 2003
Kathryn I nomally use the query builder. If I read your request correctly,I'd use something like "iif(mid$(attend,1, instr(Attend,"=") +1 ) = '35'" as your condition and something like "val(mid$(Attend,instr(Attend,"=") +1 , 1 )" as your replace statement for Attend35 Dave ----- Original Message ----- From: Kathryn Bassett To: dbAdvisors (AccessD) Sent: Thursday, June 19, 2003 5:51 PM 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030619/30a86a7c/attachment-0001.html>