Malawless
asked on
Getting Left part of string to a comma in access
I know this easy but cant seem to find my notes.
Need to break address apart all in one field in access 4310 N 4th ST. , Kansas City. Just want the address. I would use the left([Address] but don't don't know what to put to tell it to stop at the comma.
Need to break address apart all in one field in access 4310 N 4th ST. , Kansas City. Just want the address. I would use the left([Address] but don't don't know what to put to tell it to stop at the comma.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER