G Guest Dec 9, 2004 #1 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?
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] Dec 9, 2004 #2 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)
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)
