Link to home
Start Free TrialLog in
Avatar of Malawless
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.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Malawless
Malawless

ASKER

Don't you wish everyone would ask you such easy questions.  Did it years ago and spent all morning tearing up my notes and couldn't find it.  Thank you