Removing data to the right of a charachter

[JustATheory]

I'm having trouble removing some data from a record within a field. I need to remove a dash and all data to the right of it. Using a query.

Any help is well appreciated.
Thanks,
Andy

 

[SBerthold]

see Access Help on the InStr() and Left() functions

 

[cranebill]

update yourtable
set yourfield = left(yourfield, instr(yourfield,'-')-1)
where instr(yourfield,'-') > 0;