Extracting text from field

  • Thread starter Thread starter bkhiggins
  • Start date Start date
B

bkhiggins

Is there a way to extract text from a filed up to a certain character?
for instance I have a text field with data in the the following format:

"data I want to report on (data I dont want)"

I have a report that I only what the text before the first parenthsis.
Can this extract be done in Access 2003?

Thanks for any help.
 
Try the Left() and Instr() functions.
Left([FieldName], Instr([FieldName] & "(", "(" )-1)
 
Back
Top