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.
MalawlessAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
left([Address], instr([Address],",")-1)
0
 
MalawlessAuthor Commented:
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
0
All Courses

From novice to tech pro — start learning today.