Extracting text from field

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.
 
D

Duane Hookom

Try the Left() and Instr() functions.
Left([FieldName], Instr([FieldName] & "(", "(" )-1)
 
Top