select text to the left of a comma - Access

G

Guest

I have a field that is combined name and city (XYZ Coffee Shop, madison)
How can I display just the text to the left of the comma?
 
K

Ken Snell [MVP]

Assuming that you want to display this in a query, use a calculated field as
one of the query's fields:

JustTheLeftStuff: Left([FieldName], InStr([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

Suppress comma in calculated field given Null 1
how to find a second comma in a text 9
parsing query 5
Multi-word string from one field to two fields 2
Create string of text from several fields eliminating last comma 6
Sum expression over two records 6
Access query with IIF statements is null for a field and not null 3
Multiple Commas 3

Top