access 2003 parse data length undetermined

LadyHagood
LadyHagood used Ask the Experts™
on
Hi.  I have an access db.  in this db are is a table called recordlisting with several fields among with is a field called "name".  the usual entry would be something like COP-Katherine Smith  (made up of doc typ, COP, and party name, Katherine Smith.  When running a report, i need to pull the name field but only the Katherine Smith part ...so everything after the " - " character.  The first few letters may be 3 letters like in this example of several such as Complaint - Charles Johnson.  Is there anyway when runing the report or even a query to only show everything after the " - "?  THanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
you can get the name with

       trim(mid([name], instr([name],"-")+1))

Author

Commented:
worked!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial