Re: [ms_access] Remove characters from a string

[L Tumbulu]

Ian

Use the Val function to convert a string to a number. For example Val('123456') 
returns 123456 and Val(123City) returns 123. So you would have Val(PutYour 
StringHere) to come up with the number.

HTH

Liveson


  ----- Original Message ----- 
  From: ian_stevenson200 
  To: ms_access@yahoogroups.com 
  Sent: Wednesday, 08 April, 2009 15:44 PM
  Subject: [ms_access] Remove characters from a string





  Hi,

  I have a field (StudID) that has numbers but they are surrounded by quotes

  e.g '123456' 

  Is there a way in a query that I can remove these quotes so that i can return

  123456

  Thank for any help

  Ian



  

[Non-text portions of this message have been removed]