All Data in a string before space or "-"

[MadMax7]

Hope someone can help i have the following code that returns any data before a space in the name field

Left([Name],InStr([Name] & ' ',' ')-1)

i also have the following code that returns any data before a "-"

Left([Name],InStr([Name] & "_","_")-1)

i was wondering if it would be possible to combine the 2 lines of code so it looks for any data before a space or a "_" hope someone can help

 

[dhookom]

Try something like:
Left([Name],InStr(Replace([Name]," ","_") & "_","_")-1)


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]