Access Access 2007 Delete Part of Text

Feb 6, 2014
Reaction score

I am trying to create a query that deletes part of a text in a certain column. The length of the text that needs to be delete varies, but the one thing they all have in common is the word "Location" So I want all text, including the word location, after to be removed and everything else that is in the cell kept the same. Below is an example:

john smith 123 main st anytown us 12345 Location: Business - Status: Active

The location type and status have different types so that text length could vary.
I just need the fields to have

john smith 123 main st anytown us 12345
I have around 30,000 records that I need to update like this, I am trying to avoid just doing a find/replace operation for some many records

Any help would be apreciated


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