<div>
Don't you wish everyone would ask you such easy questions. &nbsp;Did it years ago and spent all morning tearing up my notes and couldn't find it. &nbsp;Thank you
</div>


<div>
<div class="content wysiwyg-content">
I know this easy but cant seem to find my notes. &nbsp;<br />
Need to break address apart &nbsp;all in one field in access 4310 N 4th ST. , Kansas City. &nbsp;Just want the address. &nbsp;I would use the left([Address] but don't don't know what to put to tell it to stop at the comma.
</div>
</div>


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.

Getting Left  part of string to a comma in access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.