Solved

Getting Left  part of string to a comma in access

Posted on 2013-11-13
2
226 Views
Last Modified: 2013-11-13
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
Comment
Question by:Malawless
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39646263
left([Address], instr([Address],",")-1)
0
 

Author Closing Comment

by:Malawless
ID: 39646412
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

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question