Hide all characters after "hyphen"

S

sonofroy

I have a field with records that are in this order

Location1 - Material Name
Location2 - Material Name
Location3 - Material Name

I would like the query to only return the field with everything after the
hyphen to be removed for example

Location1
Location2
Location3

How can I query this without actually trimming the original values out?

Thanks
 
D

Daryl S

Sonofroy -

Try this (in a query, form, etc.), substituting the right fieldName. The
InStr function will find the first "-" in your field, the Left function will
pull the leftmost characters of the fieldName (the -1 is needed so it doesn't
pull the "-"), and the Trim will remove any extra spaces before and after the
result.

=Trim(Left([fieldName],InStr(1,[fieldName],"-")-1))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicating data according to Dates 2
Remove all characters after "hyphen" in field 3
Method for Transferring Data 2
separating data before and after a hyphen. 3
Partial text returned from a query 0
Linked Tables Append Query(ies) 4
Selectively Update Field in Table 2
Data from synchronized list box on a form not entered into table bound to the form 3

Top