[AccessD] Update query syntax

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>


More information about the AccessD mailing list