Trimming Data

[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

 

[Dan Artuso]

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)