HELP: Remove characters after hyphen in access database

Question

Hi All,

I have an access database where for one field I have number in following format:

1234 - 5678

How can I get rid of the characters listed after the hyphen? i.e. "5678"

I could update it manually, but I have 100's of such numbers.

Is there a function that I can use in a Query to make this happen?

Thanks in advance

Answer 1

UPDATE YourTable

SET YourField = Trim(Left([YourTable].[YourField],Instr(1,[YourTable].[YourField],"-")-1))

WHERE YourField Like "*-*"

The expression you need to put in the Update to is

     Trim(Left([YourTable].[YourField],Instr(1,[YourTable].[YourField],"-")-1))

The criteria is

     Like "*-*"

---

John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County

Answer 2

Worked out great!

Thanks John