select text to the left of a comma - Access

M

mosko

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)
 
Top