Extracting text from field

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

 

[Duane Hookom]

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

 

[bubba]

Thanks Duane, worked like a charm...