Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

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.
0
Malawless
Asked:
Malawless
1 Solution
 
Rey Obrero (Capricorn1)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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now