troubleshooting Question

Delete Text of a record under a field in an Access 2016 Query (not update query) and I need to replace Some Text Completely.

Avatar of rnhturner1
rnhturner1 asked on
Microsoft Access
17 Comments1 Solution42 ViewsLast Modified:
I am running a query on a table and the query is all set with the exception of I need to change some text.  KEEP in mind I am a newbie with ACCESS and I am making all changes from the "Design View" on a query.  So if you are not using this route it will not help me that much right now.

Question 1:
I have a field name "Categories"
I have multiple records like below under that field like below:

SDBS SES
AS400
Exchange
SDBS Link
SDBS Microsoft

I need to get rid of "SDBS" but then keep the rest of the string.  So "SDBS SES" would only become "SES"

This has to be in a query and not an update for my purposes.

Question 2:

I need to completely change the text of a record to something entirely different.

For Example I need "SDBS Link" to be change to "Messenger"
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros