extracting information before a comma in a field

B

bird lover

I am a non-programmer working in access 2003. I have the following in field
[address]
750-44 Oakland St, Islip (Town, Outside Of Villages), NY

I want to run a query that will look for the first comma and take the
preceding data and put it into field [street]. In the above example, 750-44
Oakland St will be placed into the street field. A sample syntax would be
appreciated that I could stick in an update query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
stripping off characters after a comma 4
Drop down lists in seperate columns 5
Stripping city from address field and placing into city field 3
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Remove a comma 1
Comma separated values in a single field 1
Delete all data after a symbol in a field 0

Top