Trimming Data

  • Thread starter Thread starter Dean Knox
  • Start date Start date
D

Dean Knox

Hi,

Hope some one can help.

If I have this figure D/123456789-10, and I want to update
it using a query (that can be applied to a whole range of
numbers in the same format) to this format 123456789 does
anyone know what query and what function I would use?

Thanks

Dean Knox
 
Hi,
Are all the values in that format?
If so you can use the Mid function within a query.

*untested*

Update yourTable Set yourField = Mid(yourField,3,InStr(1,yourField,"-",1) -1)
 
Back
Top